effects of renaming partitioned Table
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 5 of 5

Thread: effects of renaming partitioned Table

  1. #1
    Join Date
    Dec 2003
    Posts
    1

    effects of renaming partitioned Table

    Dear All

    We have a partitioned table CALL and this is partitioned according to the months.One of it's partitions has grown to around 56 GB and is still growing as data for forthcoming months is also going into this partition.
    This CALL table has several procedures as well as packages associated with it. Now we have decided to rename this table and then re-create a new partitioned table month wise and then copy the data back into this new table. But the problem is that when i rename the table all my procedures and packages will get invalid ,

    My Questtion is that when i create a new partitioned table CALL then will all my procedures and packages get validated and also my application will get back to normal.

    Thanks and Regards

    kvjoy

  2. #2
    Join Date
    Jan 2001
    Posts
    2,828
    Hi

    They will get invalidated..but you need not worry as they will get compiled automagically the next time they are called by your application.

    regards
    Hrishy

  3. #3
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,333
    im probablt missing something, but if you rename a table wont all your packages which reference this table need to be changed for the new table name?

  4. #4
    Join Date
    Aug 2002
    Location
    Colorado Springs
    Posts
    5,253
    My read is that kvjoy will be renaming the table so that a new (partitioned) one can be created in it's place (with the old name).
    David Aldridge,
    "The Oracle Sponge"

    Senior Manager, Business Intelligence Development
    XM Satellite Radio
    Washington, DC

    Oracle ACE

  5. #5
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,333
    once I read it again that would make perfect sense :-)

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