Database Administration (MOSC)

MOSC Banner

1 table owned by 2 users?

edited Dec 8, 2011 5:59PM in Database Administration (MOSC) 3 commentsAnswered
Hi,
I have the situation in our database : one table owned by 2 users.

SQL> select owner
  2  from dba_tables
  3  where table_name = 'FND_PRODUCT_INSTALLATIONS' ;

OWNER
------------------------------
ORAAUDIT
APPLSYS


If I drop ORAAUDIT user (drop user ... cascade), will it also drop FND_PRODUCT_INSTALLATIONS table? Please advise..

Thanks

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center