Skip to Main Content

SQL & PL/SQL

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!

export from partiton p1 from Database D1 and import to partition p2 of D2

venkatMar 24 2011
Hi,

I need to export one of the table partition(Range Partition) data from production database P1, and Import into another table partition of database T1.

Means export from one partiton to another partition, from database is P1, To database is T1.

exp command not worked in sqlplus prompt at SQL>.

Regards,
Venkat.
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Apr 21 2011
Added on Mar 24 2011
0 comments
181 views