| List of redundant tables. [message #56043] |
Mon, 03 March 2003 23:29  |
Mukesh Raj Singh
Messages: 9
Registered: March 2003
|
Junior Member |
|
|
Sir/Madam
I just want to know which tables are owned by more than one user i.e. the same table may exist in more than one schema that may cause redundancy and unnecessary occupy space. So how to find the list of tables where owner is more than one.The user might have imported or created the similar table in other schema. so the same data exists in more than one schema.
rgds
Mukesh
|
|
|
|
| Re: List of redundant tables. [message #56046 is a reply to message #56043] |
Tue, 04 March 2003 02:44  |
Phiphat K
Messages: 5
Registered: February 2003
|
Junior Member |
|
|
Select a.table_name,a.owner,b.owner
from dba_tables a,dba_tables b
where a.table_name = b.table_name
and a.owner <> b.owner
or
Select table_name,count(table_name)
from dba_tables
group by table_name
having count(table_name) > 1
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
