Home » RDBMS Server » Performance Tuning » convert partition table to normal table
convert partition table to normal table [message #179203] Mon, 26 June 2006 06:03 Go to next message
shaygilad
Messages: 3
Registered: April 2006
Junior Member
Hi
I have a partiton table with historical data (millions of records)
I had deleted all the data in the table, and now do not need the partition.

How can I convert this table to normal table?

Thanks
Shay

Report message to a moderator

Re: convert partition table to normal table [message #179256 is a reply to message #179203] Mon, 26 June 2006 09:05 Go to previous message
Frank Naude
Messages: 4596
Registered: April 1998
Senior Member
The easiest method is to drop the old table and create a new unpartitioned table.

Alternatively, use Oracle's DBMS_REDEFINITION package.

Report message to a moderator

Previous Topic: Configuration of PGA Aggregate Target
Next Topic: low buffer hit ratio
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Sat Mar 07 07:06:31 CST 2026
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.