List non System Objects in System Tablespace
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 7 of 7

Thread: List non System Objects in System Tablespace

Hybrid View

  1. #1
    Join Date
    Mar 2001
    Location
    New York , New York
    Posts
    577
    Hi,
    How do get a list of Non System owned objects in the system table space.

    I need this to find out whether the developers are creating objects in the system tablespace or not as I notice it growing very fast and the developers know the sys/system passwords.

    Thanks
    Ronnie

  2. #2
    Join Date
    Feb 2001
    Location
    Paris, France
    Posts
    809
    select owner, segment_name, segment_type
    from dba_segments
    where tablespace_name = 'SYSTEM'
    and owner not like 'SYS%'

  3. #3
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,095
    Originally posted by ronnie
    the developers know the sys/system passwords.
    Big problem... But that's another thread.

    Code:
    select owner, segment_name 
    from dba_segments
    where tablespace_name = 'SYSTEM'
    and owner not in ('SYS','SYSTEM')
    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."

  4. #4
    I was about to get cocky and tell pipo that system should also be in that list

  5. #5
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,448
    dunno but usually I keep user system´s objects in another tablespace, tablespace system is exsclusively for user SYS

  6. #6
    Join Date
    Feb 2001
    Location
    Paris, France
    Posts
    809
    depends ... I've seen your approach with some customers, but more often SYS and SYSTEM are all mixed together in the SYSTEM tablespace ... anyway, I still haven't seen any problem linked with that

  7. #7
    I find some thrid party products do create objects in the system tablespace.

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