Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

drop or truncate partition from partition table ?

1483049Jul 25 2016 — edited Jul 25 2016

Hi Guys,

We have 11i and R12 data in the tables, so we have partitioned that tables and make two partition one for 11i data and one for 12i data. Below are partition name details.

Partition Name is DATASOURCE_11I for 11i data.

Partition Name is DATASOURCE_12I for R12 data.

Now we wanted to drop or truncate the 11i data (i.e 11i partition DATASOURCE_11I) . So i would like to know which is best and easy method drop or truncate partition? Also please help me with the full steps ?

If any other detail is required please let me know.

Thanks in advance

Locked Post

New comments cannot be posted to this locked post.

Locked on Aug 22 2016

Added on Jul 25 2016

#general-database-discussions

7 comments

564 views