Import into partition table
I have table without partition. I have another table with same structure with partition. I would like to pull data from the first table and import the same in the second partitioned tabel.
1. Can I use exp and import utility? How?
2. Does sqlplus 'copy' supports such scenario?
3. What are the other best way to do from performance perspective? (without DB LINK)
It must be only table level export from the source and import to partition table.
Click Here to Expand Forum to Full Width