Home » RDBMS Server » Server Administration » partitioned table
partitioned table [message #264941] Wed, 05 September 2007 01:36 Go to next message
vijaychauhan
Messages: 106
Registered: December 2005
Senior Member
hi!
Is it possible to partition a table which is already created.
Re: partitioned table [message #264946 is a reply to message #264941] Wed, 05 September 2007 01:45 Go to previous messageGo to next message
Arju
Messages: 1554
Registered: June 2007
Location: Dhaka,Bangladesh. Mobile:...
Senior Member

Yes.
Re: partitioned table [message #264950 is a reply to message #264941] Wed, 05 September 2007 01:47 Go to previous messageGo to next message
vijaychauhan
Messages: 106
Registered: December 2005
Senior Member
May I know how to do it or any document which shows the syntax.
Re: partitioned table [message #264953 is a reply to message #264941] Wed, 05 September 2007 01:55 Go to previous messageGo to next message
Arju
Messages: 1554
Registered: June 2007
Location: Dhaka,Bangladesh. Mobile:...
Senior Member

Look at DBMS_REDEFINITION package.
Re: partitioned table [message #265156 is a reply to message #264953] Wed, 05 September 2007 10:00 Go to previous message
DreamzZ
Messages: 1666
Registered: May 2007
Location: Dreamzland
Senior Member
Just create the new partition table and move your data to that if you have some partition key like date or something else.And refresh the statistics.
Previous Topic: oracle home file permissions
Next Topic: difference between Database character set & National Character Set..?
Goto Forum:
  


Current Time: Sat Dec 03 20:04:30 CST 2016

Total time taken to generate the page: 0.05475 seconds