create database link oracle 11g

Tags: des style blog http os io ar file data1. Install Oracle ClinetFirst download an Oracle 11g Client to the Oracle website, but you will need to apply for an Oracle account before you can download it.Current: http://www.oracle.com/technetwork/

!) Unusual situations. Oracle database administrators responsible for database backup and recovery operations. Directory1. introduction 2. jump-Starting RMAN 3. using the Flash Recovery Area 4. using the RMAN Client 5. locking ing the RMANEnvironment 6. using the Recovery Catalog 7. backing up with RMAN 8. maintaining RMAN 9. scripting RMAN 10. restoring the Co

to the Tnsnames.ora file. For example, my machine is: d:/instantclient_11_2/network/admin4. Set the language of Oracle, add the environment variable Nls_lang, and the value is simplified Chinese_china. Zhs16gbkAssuming that the Oracle language of the remote database is unclear, SSH or telnet to the remote machine, enter in the command interface, and connect to t

SQL: Oracle 11g create table, function, trigger, sequence, 11 gtrigger -- Place directory drop table BookPlaceList; create table BookPlaceList (BookPlaceID int primary key, -- NUMBERBookPlaceName nvarchar2 (500) not null, BookPlaceCode varchar (100) null, -- location parameter BookPlaceParent INT null -- BookPlaceKindI

As we all know, it is not easy to migrate a database from a higher version of Oracle to a lower version of oracle. If you directly use the SQL developer tool, you may not be able to complete the migration successfully (errors may occur more or less in the middle ). Exp and IMP are applicable to Oracle data copy and bac

Operating system: Red Hat Enterprise Linux Server Release 6.2 x86_64Oracle version: Oracle Database 11g Release 2 Oracle Official Download Address:File1:http://download.oracle.com/otn/linux/oracle11g/r2/linux.x64_11gr2_database_1of2.zipFile2:http://download.oracle.com/otn/linux/oracle11g/r2/linux.x64_11gr2_database_2o

advance). This is a dynamic parameter that can be changed in the database run:ALTER SYSTEM SET log_archive_max_processes=10;ASM-related processes: You must create an ASM instance (rebalance (Rbal), ASM rebalance (ARBN), ASM background) when using ASMManageability Monitor (Mmon): Collects centralized statistics, such as awr snapshot information, and warns you about the various dimensions of a

modifications, it became the following (I executed the ALTER DATABASE DataFile ' sql> ALTER DATABASE open;ALTER DATABASE Open*An error occurred on line 1th:ORA-01113: file 1 requires media recoveryORA-01110: data file 1: ' C:\ORACLEXE\APP\ORACLE\ORADATA\XE\SYSTEM. DBF ' sql> recover DataFile ' C:\ORACLEXE\APP\

is: Span style= "COLOR: #ff0000" > " | | Mnttime); -- set serveroutput on/off on or off display Dbms_output.put_line ( " ok, im fine " end / You can save the statement to a file and then call it with the "@/path/filename.sql".Substitution variables:SELECT empno, ename from EMP WHERE deptno= Department number;If the replacement variable provides data for a numeric column, you can drink it directly, or if you provide data for a character type or a date type, you need to enclose the

Oracle 11g Installation Prior to installation to determine their own computer configuration, in Windows, for example, if it is Win7 the following systems such as XP, you can choose Oracle 10g. Because the 10g program files only 200 trillion, and 11g and reached 2G, the official download path to the file can not be fou

does not differentiate between 64-bit and 32-bit. It seems that we can only start with Oci.dll. According to the above error message, it appears that just install a 32-bit version of Oracle Client.2. Install Oracle ClinetFirst download an Oracle 11g Client to the Oracle web

does not differentiate between 64-bit and 32-bit. It seems that we can only start with Oci.dll. According to the above error message, it appears that just install a 32-bit version of Oracle Client.2. Install Oracle ClinetFirst download an Oracle 11g Client to the Oracle web

Event Viewer, delete the Oracle-related logs DescriptionIf there are cases where individual DLL files cannot be deleted, do not bother, restart, start a new installation,When installing, select a new directory, then, after installation and restart, the old directory and files can be deleted If the article is wrong, welcome to correct, we communicate with each other. Accustomed to look at technical articles, want to get more Java resources o

The following problems are frequently encountered during data migration: 1. If the exported file is not valid, the header verification fails; 2. EXP-00056: Oracle error 6550ORA-06550: Line 1, column 41:PLS-00302: component 'set _ no_outlines 'must be declaredORA-06550: Line 1, column 15:PL/SQL: Statement ignoredEXP-00000: Export termination failed About import and export: 1. The exp command on the client must be consistent with the

Tags: style color c int strong 2014before 11g, maintaining the partition requires manual. After 11g, interval is used to automate the expansion of partitions, simplifying maintenance.According to annual INTERVAL (Numtoyminterval (1, ' Year '))according to Month INTERVAL (Numtoyminterval (1, ' month '))According to Days INTERVAL (Numtodsinterval (1, ' Day '))Here's an experiment with auto-scaling by Month:Sq

Oracle language, add the environment variable Nls_lang, and the value is simplified Chinese_china. Zhs16gbkIf you do not know the Oracle language of the remote database, you can ssh or telnet to the remote machine, enter it at the command interface, and connect to the database using the command line.SELECT * from Nls_

This article refers to the different versions of the information on the web, and then their own in the cent0s6.3 x86 and x64 two virtual environments are completed, the installation is the corresponding system of Oracle 11gx86 and x64 two versions, basic to meet the Oracle service start-up requirements. But there are a few small problems, limited capacity: 1. Start or close the service newspaper has this

. Configuring Oracle User Environment variablesVI. bash_profileExport Oracle_base=/u01/app/oracleExport Oracle_home=/u01/app/oracle/product/11.2.0/dbhome_1Export ORACLE_SID=ORCLExport path= $ORACLE _home/bin: $PATH 8. Open Xmanager Passive, execute in system[Email protected] ~]# export display=192.168.1.100:0.0(IP for machines that need to receive