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.

Report message to a moderator

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.

Report message to a moderator

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.

Report message to a moderator

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.

Report message to a moderator

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.

Report message to a moderator

Previous Topic: oracle home file permissions
Next Topic: difference between Database character set & National Character Set..?
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Mon Dec 02 07:46:38 CST 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.