Re: Import to Partitioned Table

raghu wrote:
> 1. Are there any known problems with exporting data from an
> unpartitioned table to a table which has partitions?
> 2. How different is this import different from the regular import?
>
> Thanks.
>

This is no different. Just export the table's data to a dump file. Precreate the new partitioned table. Then import into that table with IGNORE=Y. The data will fall in to the appropriate partitions.

HTH,
Brian

-- 
===================================================================

Brian Peasland
dba_at_nospam.peasland.net
http://www.peasland.net

Remove the "nospam." from the email address to email me.


"I can give it to you cheap, quick, and good.
Now pick two out of the three" - Unknown

-- 
Posted via a free Usenet account from http://www.teranews.com