Re: delete old partitions oracle 12c

Posted by ErmanArslansOracleBlog on May 11, 2017; 8:05am
URL: http://erman-arslan-s-oracle-forum.124.s1.nabble.com/delete-old-partitions-oracle-12c-tp2672p2673.html

Hi,

Send me the dbms_outputs that your script has produced.. (your script is written to output the commands before executing them)

open the dbms output, execute the script and send me the output..

The partition names that the script decides for dropping, can be wrong.

This may be related with the if statement there.. ( IF V_HIGH_VALUE <= TRUNC(SYSDATE,'MM'))

anyways, Send me the dbms_outputs that your script has produced..

2017-05-11 9:44 GMT+03:00 Roshan [via Erman Arslan's Oracle Forum] <[hidden email]>:

Oracle Database 12c
Red Hat Linux 6.7

Oracle Database 12c

Red Hat Linux 6

 

Hi,

I have a script to delete old partitions. I have executed the script, and old partitions are still present.

Please find attached.

deletescript.txt

Please advise.

Regards,
Roshan

---

If you reply to this email, your message will be added to the discussion below:

http://erman-arslan-s-oracle-forum.2340467.n4.nabble.com/delete-old-partitions-oracle-12c-tp2672.html

To start a new topic under Scripting Bash / Sql / Perl, email [hidden email]
To unsubscribe from Erman Arslan's Oracle Forum, click here.
NAML

--