Oracle Database Discussions

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!

split table into multiple table

user10188639Oct 30 2013 — edited Oct 30 2013

Hi Guys,

i have to divide one table into multiple tables having 10 millions of records. i can not find any partition key in that table many duplicates are there. I tried approach of adding sequence column and divide, but it taking lot of time.

what other approach i should look for.

DB-Oracle 11G

OS-Linux

Locked Post

New comments cannot be posted to this locked post.

Locked on Nov 27 2013

Added on Oct 30 2013

#general-database-discussions

7 comments

2,308 views