custom objects in oracle created users(like system)
DBAsupport.com Forums - Powered by vBulletin
Page 1 of 2 12 LastLast
Results 1 to 10 of 20

Thread: custom objects in oracle created users(like system)

Hybrid View

  1. #1
    Join Date
    Apr 2004
    Posts
    6

    Question custom objects in oracle created users(like system)

    we all know that Oracle doesn't recommend creating custom objects in those sacred accounts (like sys, system, etc...)
    I would never create a table but package or procedure seems to be safe enough to me...
    Could someone explain me why ?

  2. #2
    Join Date
    Aug 2002
    Location
    Colorado Springs
    Posts
    5,253
    Because Oracle says not to -- good enough for me.
    David Aldridge,
    "The Oracle Sponge"

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

    Oracle ACE

  3. #3
    Join Date
    Dec 1999
    Posts
    217
    Oracle suggests not to do so, 'cause the tablespace would get fragmented due to the user objects which in turn will affect the performance of the database.

    -Chintzs

  4. #4
    Join Date
    Aug 2002
    Location
    Colorado Springs
    Posts
    5,253
    *cough* bullsht *cough*

    David Aldridge,
    "The Oracle Sponge"

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

    Oracle ACE

  5. #5
    Join Date
    Apr 2004
    Posts
    6
    Chintz,
    I agree with you about tables but package won't cause any fragmentation....
    what do you think about packages,and other pl-sql under sys, system, etc...?

  6. #6
    Join Date
    Sep 2003
    Location
    over the hill and through the woods
    Posts
    995
    Originally posted by lanna
    Chintz,
    I agree with you about tables but package won't cause any fragmentation....
    what do you think about packages,and other pl-sql under sys, system, etc...?
    Sounds to me like someone made an "ooops" and is trying to it cover up.
    Oracle it's not just a database it's a lifestyle!
    --------------
    BTW....You need to get a girlfriend who's last name isn't .jpg

  7. #7
    Join Date
    Apr 2004
    Posts
    6
    OracleDoc,

    "Oops" is not done yet. But i'm planning to do it. So far I don't see any reasonable answers on my question and "because I said so" is not good enough for me

  8. #8
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,092
    Originally posted by lanna
    OracleDoc,

    "Oops" is not done yet. But i'm planning to do it. So far I don't see any reasonable answers on my question and "because I said so" is not good enough for me
    Then I suggest you go for it and learn the hard way.
    Jeff Hunter
    marist89@yahoo.com
    http://marist89.blogspot.com/
    Get Firefox!
    "I pledge to stop eating sharks fin soup and will not do so under any circumstances."

  9. #9
    Join Date
    Aug 2002
    Location
    Atlanta
    Posts
    1,187
    Originally posted by lanna
    OracleDoc,

    "Oops" is not done yet. But i'm planning to do it. So far I don't see any reasonable answers on my question and "because I said so" is not good enough for me
    40000 People working at Oracle say not to do that and you say otherwise, start your own revolution I guess. Why not write a White paper on How I learned to stop worrying and create objects Willy Nilly in the system tablespace?
    I'm stmontgo and I approve of this message

  10. #10
    Join Date
    Dec 2002
    Location
    Bangalore ( India )
    Posts
    2,434
    Originally posted by lanna
    OracleDoc,

    "Oops" is not done yet. But i'm planning to do it. So far I don't see any reasonable answers on my question and "because I said so" is not good enough for me
    Well.. dont think in perspective of DB/DB Performace/Blah.. Blah..

    But think at an application point of view and also manageability.. then you will get your answers..

    Abhay.
    funky...

    "I Dont Want To Follow A Path, I would Rather Go Where There Is No Path And Leave A Trail."

    "Ego is the worst thing many have, try to overcome it & you will be the best, if not good, person on this earth"

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