|
-
DBA_SEGMENTS does not show all objects, like LOB Indexes.
Use this quote:
select 'SEGMENTS' tipo, owner, segment_name, TABLESPACE_NAME from dba_segments where TABLESPACE_NAME <> 'TSD_DBAMLAT' and owner in ('CAP_WATTS','DBAMLAT')
union
select 'TABLES' tipo, owner, table_name, TABLESPACE_NAME from dba_tables where tablespace_name <> 'TSD_DBAMLAT' and owner in ('CAP_WATTS','DBAMLAT')
union
select 'INDEXES' tipo, owner, index_name, TABLESPACE_NAME from dba_indexes where tablespace_name <> 'TSD_DBAMLAT' and owner in ('CAP_WATTS','DBAMLAT')
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
|