<div>
ALTER TABLE &lt;PARTITIONNED_TABLE&gt;<br />
DROP PARTITION &lt;PARTITION_NAME&gt;;<br />
<br />
<a href="http://www.oracle.com/technology/oramag/oracle/02-jan/o12part.html" rel="ugc nofollow">http://www.oracle.com/technology/oramag/oracle/02-jan/o12part.html</a><br />
<br />
<br />

</div>


ALTER TABLE <PARTITIONNED_TABLE>
DROP PARTITION <PARTITION_NAME>;

http://www.oracle.com/technology/oramag/oracle/02-jan/o12part.html [http://www.oracle.com/technology/oramag/oracle/02-jan/o12part.html]




<div>
<div class="content wysiwyg-content">
Hi,<br />
<br />
What i need to do is the following :<br />
<br />
Using the switch partition I need to create a table. Then I need to switch back the partitions.<br />
Also how can I remove unneeded partitions?<br />
<br />
Thanks
</div>
</div>


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

Using Switch Partition method in Oracle

Oracle is an object-relational database management system. It supports a large number of languages and application development frameworks. Its primary languages are SQL, PL/SQL and Java, but it also includes support for C and C++. Oracle also has its own enterprise modules and application server software.