OraFAQ Forum: Server Administration

Home » RDBMS Server » Server Administration » Redundant tables?

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Redundant tables? [message #56666]

Tue, 15 April 2003 22:45

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

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:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Sep 20 09:28:03 CDT 2024