Shulou(Shulou.com)06/01 Report--

Today, I need to make room on my computer. I found that a dbf file in oracle occupies about 30g, which is rarely used by users, so I want to deal with it-delete tablespace operation.

The native database is 32-bit 10.2.0.1.0, and there are several table data in the tablespace TEST_TB. System users with the dba role at the beginning, directly execute

Drop tablespace test_tb including contents and datafiles

Tip:

ORA-00604: an error occurred in recursive SQL level 1

ORA-38301: unable to DDL/DML objects in the Recycle Bin

Reason: the data of this tablespace test_tb exists in dba_segments, and the query can be executed through dba users:

Select segment_name,segment_type,owner from dba_segments where tablespace_name='TEST_TB'

Treatment method:

Log in with the user corresponding to the tablespace

Execute purge recyclebyin

Re-execute drop tablespace test_tb incluing contents and datafiles

After execution, the dbf file does not exist and the space is free.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.