By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
425,600 Members | 1,683 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 425,600 IT Pros & Developers. It's quick & easy.

Export Database tables to a dump file under windows

P: 42
Hi everybody,

please can somebody help me about how to write the script to export oracle database specific tables into a dump file under windowws

thank you please it is urgent
Aug 13 '08 #1
Share this Question
Share on Google+
3 Replies


debasisdas
Expert 5K+
P: 8,127
you need to use EXP or EXPDP utility from command prompt.
Aug 14 '08 #2

P: 26
try execute this in DOS prompt

exp scott/tiger@SID file=backup.dmp tables=(table1, table2, table3) log=mybackup.log
Aug 14 '08 #3

P: 42
Thank u very much, it worked with me. But i have one more question please, can u tell me the command to import the data from that exported dump file into a database.

Regards
Sep 2 '08 #4

Post your reply

Sign in to post your reply or Sign up for a free account.