EXPORT...EXPORT...EXPORT

[learn]

Assuming I exported by issuing this command: exp system/manager tables=(a, scott.b, c, mary.d)
and I want to import the same tables to a different database on the same machine, how would I go about it.
i.e. exporting from Database A and importing to Database B on the same machine.
Please give an example just as I did.
thanks

[sambavan]

the way you could do this is as follows,

exp username/passwd@instance_name TABLES=(schema.t1,schema.t2,...) FILE=your_file.dmp DIRECT = Y
COMPRESS = no

If you have setted the ORACLE_SID= ... , then you don't need to specify the instance name. If you are doing this from a remote system then, instead of instance name you would have to use the service name (db1.xyz.com) as you have specified under the tnsname.ora file.

Now comming to the point of import,

imp username/passwd@instance_name TABLES=(schema.t1,schema.t2,...) FILE=your_file.dmp ROWS=Y

to do it between different users then you would have to use the FROMUSER and TOUSER clauses


I hope this would help. If you have any questions, let us know.
Sam