| Recreating a table [message #148226] |
Wed, 23 November 2005 03:27  |
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  |
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.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
