Home » Other » General » Recreating a table
Recreating a table [message #148226] Wed, 23 November 2005 03:27 Go to next message
sellafrica
Messages: 68
Registered: July 2005
Location: Braynston
Member
HI All.

I need to recreate a table that was partitioned before to be a normal table and would like to know the best way(steps to follow) to go about this.

Re: Recreating a table [message #149215 is a reply to message #148226] Wed, 30 November 2005 10:15 Go to previous message
smartin
Messages: 1803
Registered: March 2005
Location: Jacksonville, Florida
Senior Member
I'd either create a table then use insert append. Or create table as select. Or possibly merge partitions down into one, although not sure if that last approach gets you anything, it would depend on the situation.
Previous Topic: Oracle's Web Site
Next Topic: Oracle equivalent for DIGITS and FLOAT
Goto Forum:
  


Current Time: Fri Mar 29 04:16:09 CDT 2024