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
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: 4579
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.
Previous Topic: Configuration of PGA Aggregate Target
Next Topic: low buffer hit ratio
Goto Forum:
  


Current Time: Fri Mar 29 09:36:24 CDT 2024