Oracle Import and Export ____oracle

First, create the directory folder for the exported data

Create or replace directory Oradata as ' E:\data ';

Note:

(1) The Data folder needs to be created by itself under this disk.

(2) If the prompt permission is insufficient, need to authorize to the current user

such as: Grant Read,write on directory oradata; Ii. using EXPDP to export user data (1) Only exports the SOCTT user's metadata does not contain the statistic information;

EXPDP system Directory=oradata Schemas=scott content=metadata_only exclude=statistics dumpfile=scott_meta.dmp logfile =scott_meta.log (2) only export SOCTT user's data

EXPDP system Directory=oradata Schemas=scott content=data_only

Dumpfile=scott_data.dmp Logfile=scott_data.log
(3) only emp,dept data under Scott User is exported

EXPDP Scott Directory=oradata tables=emp,dept

Dumpfile=scott_emp_dept.dmp Logfile=scott_emp_dept.log
(4) Only EMP,DEPT table structure under Scott User is exported

EXPDP Scott Directory=oradata tables=emp,dept content=metadata_only

Dumpfile=scott_emp_dept_meta.dmp Logfile=scott_emp_dept_meta.log
(5) Export all content under the SOCTT user

EXPDP system Directory=oradata Schemas=scott dumpfile=scott_all.dmp

Logfile=scott_all.log
(6) Parallel export of all content under Scott's user

EXPDP system Directory=oradata Schemas=scott dumpfile=scott_all%u.dmp

Logfile=scott_all.log parallel=2