Hi,
I have a huge table, that i want to make a partition table instead.

I have created the new partitioned table, and i want to import all the rows from the old table to the new table.
My problem is, that i takes about 2.5 hours to insert into the new table.

My question is.
Is it possible to import to an existing table??

I have tried, but a get an error IMP-00015: object already exist

Hope anyone have experienced the same thing, and have an solution

Lars
Denmark

Oracle LazyDBA home page