Skip to Main Content
Forums

SQL & PL/SQL

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!

Able to Drop partition but not truncate

574641Feb 16 2009 — edited Feb 16 2009
Hi All,

I have a database with 2 schemas. Schema S1 used for calculations and Schema S2 used for just display. I have a table T which is partitioned, in both schema S1 and S2.
I tried truncating a partition of table T that is present in schema S2, from S1. But got an error ' Insifficient privileges'
But to my surprise, I was able to Drop that partition of T (belonging to S2) sitting at S1.
How is this possible?

Thanks and Regards,
Saff
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Mar 16 2009
Added on Feb 16 2009
4 comments
376 views