purging partitions
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4

Thread: purging partitions

  1. #1
    Join Date
    Jul 2001
    Location
    Montreal
    Posts
    218

    Question purging partitions

    Hi,
    I need to write a script that will automatically remove the oldest partition and insert a new partitions. (ie remove the oldest month, then add new month's data).
    Could somebody advise where I can find a sample script that will do this task?
    I looked in metalink and found nothing usefull.
    Thanks for your support,

  2. #2
    Join Date
    Mar 2002
    Posts
    534
    where is exactly your problem?

    You simply have to add and drop a partition. The following documentation explains how you can do it:

    http://download.oracle.com/docs/cd/B...1.htm#i2131048
    http://download.oracle.com/docs/cd/B...1.htm#i2131064

  3. #3
    Join Date
    Jul 2001
    Location
    Montreal
    Posts
    218
    Hi, I do not have a problem with the syntax or concept.
    I am looking for a sample script (written in pl/sql ?) that I can use as a model to achieve this. Do you know of a website where i can find scripts that can do this?
    Regards,
    Pascal

  4. #4
    Join Date
    Mar 2002
    Posts
    534
    I'm sure that if you read the doc you should be able to do it by your own (in less then an hour).

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width