Export Database tables to a dump file under windows

[Sport Girl]

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

[debasisdas]

you need to use EXP or EXPDP utility from command prompt.

[EVH316]

try execute this in DOS prompt

exp scott/tiger@SID file=backup.dmp tables=(table1, table2, table3) log=mybackup.lo g

[Sport Girl]

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