How to Create Dump File in Oracle

We can dump Oracle database using exp command.
To dump a single schema to disk

exp <user>/<password> FIlE=scott.dmp OWNER=scott

dump a specific table:
exp SYSTEM/password FIlE=expdat.dmp TABLES=(scott.emp,hr.countries)

Note: the above command uses two users : scott and hr

Dump file for Only one user
exp <user>/<password> FILE=scott.dmp TABLES=(emp,dept)



Related Topic List of Mysql Error Code and Description
How to Create Simple Mysql Database Dump Backup on Ubuntu
How to Restore Dumped Mysql Database Backup on Ubuntu
The Client Server Approach for MySql Database Backup
ETL Script for CSV Database Table Dumps Export
SQL  oracle  

nScraps.com 2011   Privacy Policy  Terms of Service  Feedback