Our company have a data for a period of time before not make black screen virus? Our leaders decided to call a heat engine backup data I poured the database data are used to
I was at the new database above form with
Insert into table select * from table2 @ * *. commit;
The method of take an examination of the past but there is a problem of this order of large amount of data is stuck?
I want to ask god what's the other way copy large amounts of data?

CodePudding user response:

This is you use dblink performance is poor, associated with the network is very big,
Can use the rman backups or dump processing,

CodePudding user response:

Exp/expdp/rman will do ah

CodePudding user response:

Use expdp fast, forced dblink fast much and all the other objects

CodePudding user response:

Impdp + network_link, extremely fast,

CodePudding user response:

-- first engine backup is to be able to use while backup, so if the host suddenly out of order, being able to switch to a backup machine, pump is not a simple data import and export operation, the specific meaning or baidu, hot standby, I also didn't see,
- data pump import operation
Up SQLPLUS SYSTEM/123456 @127.0.0.1/ORCLPC
The CREATE in TABLESPACE "former" DATAFILE 'D: \ oracleData \ corp DBF' SIZE 30 m REUSE AUTOEXTEND ON NEXT 64 m MAXSIZE UNLIMITED LOGGING among MANAGEMENT, LOCAL SEGMENT SPACE MANAGEMENT, AUTO;
The CREATE USER "former" PROFILE "DEFAULT" IDENTIFIED BY "xpar" DEFAULT in TABLESPACE "former"
TEMPORARY in TABLESPACE "TEMP" ACCOUNT UNLOCK.
GRANT, UNLIMITED in TABLESPACE TO "former";
GRANT "DBA" TO "former";
The create or replace directory impdp_dir as' D: \ xir_database_2018-01-24 '.
Grant read, write on directory impdp_dir to former;
exit;
Impdp wouldn/123456 @ ORCLPC directory=impdp_dir schemas=former dumpfile=ORCL_2018-01-24. DMP logfile=ORCL_2018-01-30. Log

CodePudding user response:

Should not be a one-off migration, but the concept of a long-term effective backup, use rman