Query help

[bang_dba]

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.

[AOrehek]

Try this one;

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

[zquresh]

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

[davey23uk]

find some helpdesk job, no-one will employ you if you have no experience