Database Administration (MOSC)

MOSC Banner

Recyclebin concept

edited Aug 26, 2009 10:03PM in Database Administration (MOSC) 7 commentsAnswered ✓
 Hi All,

i have a doubt regd Recycle bin.

Scenario:

1. connected as 'sys as sysdba'

2. issued -> purge recyclebin

3. connected to another schema in same DB.

4. still i see objects of schema in recycle bin.

Doubt is:

does purging recycle bin purges all objects for all dba_users?

will oracle maintains seperate recycle bin for different schemas?

Thanks in Advance

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