Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

exp imp only data

user10243788Feb 6 2012 — edited Feb 6 2012

Hi all,

My database version is 10g.

I have to export tables from server1 to server2. i do not want packages and functions just the table data.

i can give exp system/pass file=test.dmp tables=

but there are a lot of tables, how i can i just export tables of user1,user2 from server1 into user1,user2 of server2 without taking packages and functions.

Locked Post

New comments cannot be posted to this locked post.

Locked on Mar 5 2012

Added on Feb 6 2012

#database-key-features, #export-import-sql-loader-external-tables

6 comments

391 views