Error ORA-30013 When Drop Tablespace

I’m changing the UNDO_TABLESPACE in a database, to reconfigure the files that are being used. Upon receipt the drop tablespace error that below. I previously ensured that there are no active transactions in the database, so that there is no segment rollback in state “pending offline”;

 
ORCLTEST>  DROP TABLESPACE UNDO_TS INCLUDING CONTENTS AND DATAFILES;
 DROP TABLESPACE UNDO_TS INCLUDING CONTENTS AND DATAFILES
*
ERROR en línea 1:
ORA-30013: el tablespace de deshacer 'UNDO_TS' está en uso actualmente

The problem in this case is the UNDO_RETENTION parameter, which is somewhat high. After spending the indicated time can drop tablespace and datafiles smoothly.

HTH – Antonio NAVARRO

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