Database Administration (MOSC)

MOSC Banner

DROP TABLESPACE ts_name INCLUDING DATAFILES takes forever

edited Nov 24, 2014 11:48AM in Database Administration (MOSC) 8 commentsAnswered ✓

Hello ,

In a production ORA 11.2.04  linux x86-64 red hat 6 I had the TEMP file 13Giga big.

to reduce the TEMP1 File size I did:

SQL> CREATE TEMPORARY TABLESPACE TEMP2 TEMPFILE '/cluster/extpkg9/oradata/ORA1EXT/temp02.dbf' SIZE 2000M REUSE AUTOEXTEND ON NEXT 1M MAXSIZE unlimited EXTENT MANAGEMENT LOCAL UNIFORM SIZE 1M;

Tablespace created.

SQL> ALTER DATABASE DEFAULT TEMPORARY TABLESPACE TEMP2;

Database altered.

SQL> DROP TABLESPACE temp INCLUDING CONTENTS AND DATAFILES;

after 2 hours I stop the process

How can complete this ? my disk is 86% FULL Is there a workaround to free disk place?

regards

Giorgio

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