How to Import and Export a Database Dump in Oracle
The following instruction will help us in importing and exporting our oracle database. Create and restore dump file (http://www.datab...
https://www.czetsuyatech.com/2021/07/oracle-export-import-database-dump.html
The following instruction will help us in importing and exporting our oracle database.
- Create and restore dump file (http://www.database.fi/2011/05/using-expdp-and-impdp-export-and-import-in-10g-11g/)
- Create dump file
- sqlplus system/oracle
- SQL> create directory dmpdir AS 'c:\temp';
- select directory_name, directory_path from dba_directories;
- expdp system/password version=’10.2.0.1’ dumpfile=czetsuya.dmp directory=dmpdir schemas=czetsuya
- Restore a dump file
- For import we can use the DATA_PUMP_DIR setting:
- ORACLE_XE\app\oracle\admin\XE\dpdump
- Copy dump file to folder above
- impdp system/password dumpfile=czetsuya.dmp directory=DATA_PUMP_DIR full=y logfile=czetsuya.log
Post a Comment