Oracle migration from a remote machine to a Local Machine

 

For Oracle databases of the same type:

, 1,DataSmall Amount (table): dblink can be used.

If you copy data between Oracle databases, use the create table as and insert SQL commands.

Create Table om_serv_income _ & sum_monthNologgingAs
Select\ * + Parallel (A, 5 )*\* From
Odsc_gz.om_serv_income _ & sum_month @Odscold;

==> Remote database connection not found

Create a database link.

Create public database link AA connect to zqticket identified by 'zqticket !! 'Using' zqsjlm'

 

2. Large data volume: In the CMD command, exp and IMP are used.

ExpZqticket/zqticket !! @ Zq_ticket215File = F:/zq_ticket215.dmp full = y
IMPScott/tiger @ orclFile = F:/zq_ticket215.dmp full = y ignore = y

 
Exp system/manager @ A file = fullbak. dmp log = fullbak. Log full = y
 

 
IMP system/manager @ B file = fullbak. dmp ignore = y
 

The above may be a problem, because some tables already exist, and then it will report an error, the table will not be imported.Add ignore = Y to the end.
 

 
IMP system/manager file = bible_db log = dible_db full = y ignore = y
 

 
System/manager is the user name and password
 

 
File = bible_db is the file to be imported
 

 
Log = dible_db is the name of the generated log
 

 
Full = y is used to import the entire file.
 

 
Ignore = y indicates that the creation error is ignored.
 

   
 you must have the same tablespace as A. For example, if you have a test tablespace in Table, you must also have 
 
  3, tens of millions   data volume (table): Archive mode. Add   nologging   . 
 
 Create Table as select... 
 
 Create a table with the same structure. Then, use the append parameter 
 
 in non-archive mode: 
 
 insert/* + append */into a select * from B; 
 
 in archive mode: 
 
 insert/* + append */into a   nologging   select * from B; 
 
  4. Use the Copy command between different databases:  
 
 in  SQL * Plus , supports remote databases, local databases, Oracle databases, and non-Oracle databases. Data replication between databases. Its performance is the same as that of import/export. 
 
 http://sd8089730.iteye.com/blog/1147895