Skip to content
September 23, 2016 / doganay

ORA-01555 WHILE DROPPING TABLESPACE

SQL> drop tablespace tbs1 including contents and datafiles;
drop tablespace tbs1 including contents and datafiles
*
ERROR at line 1:
ORA-00604: error occurred at recursive SQL level 1
ORA-01555: snapshot too old: rollback segment number 0 with name "SYSTEM" too
small

SQL> PURGE dba_RECYCLEBIN;

DBA Recyclebin purged.

SQL> 
SQL> drop tablespace tbs1 including contents and datafiles;

Tablespace dropped.
Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: