Home » SQL & PL/SQL » SQL & PL/SQL » Converting a table to be a partition of a partitioned table
Converting a table to be a partition of a partitioned table [message #188567] Sat, 19 August 2006 16:37 Go to next message
Abraham
Messages: 6
Registered: August 2000
Location: New Jersey
Junior Member

I am not able to find the syntax to do this. I have searched the dataware house guide and the administrator's guide.

I have a table T with data and I have a partitioned table P with partitions that have data. I would like to make table T be an additional partition of table P.

Thanks.
Re: Converting a table to be a partition of a partitioned table [message #188586 is a reply to message #188567] Sun, 20 August 2006 05:05 Go to previous message
rleishman
Messages: 3724
Registered: October 2005
Location: Melbourne, Australia
Senior Member
Look in the Oracle SQL Reference under ALTER TABLE, and search for EXCHANGE PARTITION.

Ross Leishman
Previous Topic: storage of tables
Next Topic: Pass type of an Array to a procedure
Goto Forum:
  


Current Time: Sun Dec 11 04:05:29 CST 2016

Total time taken to generate the page: 0.07368 seconds