How can we copy a file or anything from one database to another database using export and import?
Printable View
How can we copy a file or anything from one database to another database using export and import?
This is the example to export a single table
exp scott/tiger file=emp.dmp log=emp.log tables=emp rows=yes indexes=no
To export multiple tables at a time specify table names seperated by , as follows
Tables = (emp,dept,...)
To get further help regarding IMP and EXP go to BIN path of orahome then type
EXP HELP = YES
what do you mena by [b]copy a file or anything from one database to another database [/b] ?