Home » RDBMS Server » Server Administration » Redundant tables?
Redundant tables? [message #56666] Tue, 15 April 2003 22:45 Go to next message
rajmukesh
Messages: 14
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

Report message to a moderator

Re: Redundant tables? [message #56667 is a reply to message #56666] Tue, 15 April 2003 23:55 Go to previous message
Maaher
Messages: 7065
Registered: December 2001
Senior Member
 
select t.table_name
     , d.owner
  from dba_tables d
     , ( select table_name
           from dba_tables
          group by table_name
         having count(*) > 1 ) t
  where d.table_name = t.table_name
Beware though, you should verify each case to be sure it is redundant.

MHE

Report message to a moderator

Previous Topic: Personal Oracle
Next Topic: Urgent!!! How to Change Dedicated Server to Shared Server?
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Sun Dec 29 14:19:31 CST 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.