changing #owner column in sys.obj$
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 5 of 5

Thread: changing #owner column in sys.obj$

  1. #1
    Join Date
    Nov 2002
    Posts
    80

    changing #owner column in sys.obj$

    I want to move some tables from one schema to another, in the same tablespace.

    I've read that changing sys.obj$ will work but it's not recommended by oracle. Anyone know the reason why it's not recommended?

  2. #2
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,333
    would of though it was obvious - because there is a big chance of breaking everything severly.

    Probbaly quicker to do it the proper way as well

  3. #3
    Join Date
    Feb 2000
    Location
    Washington DC
    Posts
    1,843
    Sys schema is Oracle Super user schema, Oracle doesn't like people playing with it our own way(not oracle recommeded way) and appraoch them saying, my database is corrupt.

    There are some undocumented procedures exists in real world which are succesful in implemetation but, those are published by experts who tested in their test environments and says it works. But, experts know all the implications of doing those undocumented/not recommended procedures.

    Hope you got it.
    Reddy,Sam

  4. #4
    Join Date
    Nov 2002
    Location
    New Delhi, INDIA
    Posts
    1,796

    Re: changing #owner column in sys.obj$

    Originally posted by onlysimon
    I want to move some tables from one schema to another, in the same tablespace.

    I've read that changing sys.obj$ will work but it's not recommended by oracle. Anyone know the reason why it's not recommended?
    Take it from me don't touch those tables... I did it once on my test database and every thing went beserk....

    Had to recreate the database.
    Amar
    "There is a difference between knowing the path and walking the path."

    Amar's Blog  Get Firefox!

  5. #5
    Join Date
    Nov 2002
    Posts
    80
    okeydoke, i get the message.

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