-
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
-
select owner, segment_name, segment_type
from dba_segments
where tablespace_name = 'SYSTEM'
and owner not like 'SYS%'
-
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
-
I was about to get cocky and tell pipo that system should also be in that list
-
dunno but usually I keep user system´s objects in another tablespace, tablespace system is exsclusively for user SYS
-
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
-
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
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|