-
Query help
Hi,
I am looking for a query which will list all TABLES with Tablspace name, which have their index segments created on different Tablespace, than that of the table segments.
------------------------------------------------------------------------
The most enjoyable things in the world are either Immoral or too Expensive or otherwise Inaccessible anyway
-
Try this one;
Code:
SELECT t.owner, t.table_name, i.index_name,
t.tablespace_name "Table tablespace" ,
i.tablespace_name "Index tablespace"
FROM dba_indexes i, dba_tables t
WHERE i.owner = t.owner
AND i.table_name = t.table_name
AND i.tablespace_name != t.tablespace_name
Aleš Orehek
-
hai !
my name is zakir and i am an oracle certified associtae and want to start my career as a junior dba but i am unable to find the means hoa can i go for it please do help me
-
find some helpdesk job, no-one will employ you if you have no experience
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
|