Import into partition table

[sumit]

Hi,

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)

Thanks
Sumit

[sumit]

Hi Guys

Got it.

It must be only table level export from the source and import to partition table.

Thanks