Export Import database

[sumandba]

How can we copy a file or anything from one database to another database using export and import?

[krishnaindia2007]

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

[debasisdas]

what do you mena by copy a file or anything from one database to another database ?