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: dead lock
Next Topic: oracle home file permissions
Goto Forum:
  


Current Time: Sun Aug 20 06:55:17 CDT 2017

Total time taken to generate the page: 0.01525 seconds