Cosine_Consultants
asked on
Using Switch Partition method in Oracle
Hi,
What i need to do is the following :
Using the switch partition I need to create a table. Then I need to switch back the partitions.
Also how can I remove unneeded partitions?
Thanks
What i need to do is the following :
Using the switch partition I need to create a table. Then I need to switch back the partitions.
Also how can I remove unneeded partitions?
Thanks
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
DROP PARTITION <PARTITION_NAME>;
http://www.oracle.com/technology/oramag/oracle/02-jan/o12part.html