Database DataWarehousing (MOSC)

MOSC Banner

Oracle 11gR2 - Partitioning

edited Feb 23, 2012 7:45AM in Database DataWarehousing (MOSC) 3 commentsAnswered ✓
I'm trying to develop a couple of scripts to drop partitions one for monthly and the other for dailies for more than one table. However I'm having issues with high_value. I have the following that I put together using a packaged function written by Tom Kyte but I need to omit the high_value results so I only get the drop statements. Any help is appreciated.

create or replace
package system.long_help
authid current_user
as
    function substr_of
     ( p_query in varchar2,
       p_from  in number,
       p_for   in number,
       p_name1 in varchar2 default NULL,
       p_bind1 in varchar2 default NULL,

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center