Home » RDBMS Server » Server Administration » How to find tables owned by multiple users?
How to find tables owned by multiple users? [message #56026] Mon, 03 March 2003 05:23 Go to next message
Mukesh Raj Singh
Messages: 9
Registered: March 2003
Junior Member
Sir/Madam
Tell me how to find the tables that are owned by multiple users as this increases redundancy and unnecessarily increases the database size.
rgds
Mukesh
Re: How to find tables owned by multiple users? [message #56029 is a reply to message #56026] Mon, 03 March 2003 05:46 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
logically,
a table is owned by only one user.
there might be many similiar tables ( like the demo tables emp, dept) in many schemas.
so what are u exactly looking into?
mag@itloaner1_local > ED
Wrote file afiedt.buf

  1   select table_name,owner  from dba_tables
  2   where owner not in ('SYS','SYSTEM') AND TABLE_NAME='EMP'
  3*  ORDER BY TABLE_NAME
mag@itloaner1_local > /

TABLE_NAME                     OWNER
------------------------------ ------------------------------
EMP                            MAG
EMP                            SCOTT

mag@itloaner1_local > 

Re: How to find tables owned by multiple users? [message #56037 is a reply to message #56026] Mon, 03 March 2003 10:22 Go to previous message
sai sreenivas jeedigunta
Messages: 370
Registered: November 2001
Senior Member
I will totally agreee with what Mahesh said ? Tell us what are u looking at ?

sai
Previous Topic: ORA-12541: TNS:no listener error
Next Topic: Default SGA size ?
Goto Forum:
  


Current Time: Sat Dec 28 22:35:55 CST 2024