Re: Break a table into small finite tables

From: Daniel Roy <danielroy10junk_at_hotmail.com>
Date: 21 Jul 2003 13:14:46 -0700
Message-ID: <3722db.0307211214.36b90e1c_at_posting.google.com>


Instead of re-inventing the wheel, why don't you partition your table? First find the most convenient field(s) to use for the definition of the partitions.

Daniel

> Hi Oracle Xperts,
>
> I am trying to break a 10 million accounts table into 5 tables with 2
> million accounts each. I tried using rownum but am having problems
> with it. Is there any other way that I can do this?
>
> Many thanks,
>
> Krishna.
Received on Mon Jul 21 2003 - 22:14:46 CEST

Original text of this message