Oracle Data Pump usage (1)

Oracle Data Pump usage (1) Oracle Data Pump expdpimpdp I. Data Pump export steps: 1. Create a directory (I created it using a system user, scott user does not have permission)

create directory dump1 as 'e:\dump' ;

 

2. Authorize scott user

grant read,write on directory dump1 to scott;

 

3. Exit the system user and execute the export operation C: \ Documents ents and Settings \ Administrator> expdp scott/orcl directory = dump1 dumpfile = aaaaa. dmp; 4. Export successful! 2. Use the Data Pump to import: C: \ Documents ents and Settings \ Administrator> impdp scott/orcl directory = dump1 dumpfile = AAAAA. dmp Note: If you have changed the exported file aaaaa. the location of dmp or you have executed the drop directory dump1; you also need to perform steps 1 and 2 in the export step before importing. 3. View expdp or impdp parameter usage C: \ Documents ents and Settings \ Administrator> expdp help = y or C: \ Documents and Settings \ Administrator> impdp help = y 4. Create, delete, and view directory Methods

Create directorycreate directory dump1 as 'e: \ dump'; Delete the created directorydrop directory dump1; query directoryselect * from dba_directories;

 

5. authorize different users to create or delete directories

Grant create any directory to scott; grant drop any directory to scott; revoke the following permissions: revoke create any directory from scott; revoke drop any directory from scott;