Re: copying from unpartitioned to partitioned table
Posted by:
Rick Casey
Date: March 12, 2010 10:58AM
Thanks for this reply.
To answer your question, we need to query this table for specific phonenumber data; so I see your point about not casting phonenumber as an integer.
Fortunately, none of the phonenumbers have any characters other than numbers; but there are numbers with leading zeros. (At least, I hope so; haven't seen every record in this 430MM+ record table.)
I will try to use the KEY method of partitioning.
One other question: will partitioning help speed up index building?
Subject
Views
Written By
Posted
3879
March 09, 2010 11:54AM
2172
March 11, 2010 08:18AM
Re: copying from unpartitioned to partitioned table
2016
March 12, 2010 10:58AM
1861
March 24, 2010 08:39AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.