Solved

tablespace

Posted on 2012-03-23
6
525 Views
Last Modified: 2012-04-03
why I cannot drop tablespace...


SQL> select tablespace_name from dba_tablespaces;

TABLESPACE_NAME
------------------------------
SYSTEM
SYSAUX
UNDOTBS1
TEMP
USERS
EXAMPLE

6 rows selected.

SQL> drop tablespace example;
drop tablespace example
*
ERROR at line 1:
ORA-01549: tablespace not empty, use INCLUDING CONTENTS option


SQL> drop tablespace EXAMPLE;
drop tablespace EXAMPLE
*
ERROR at line 1:
ORA-01549: tablespace not empty, use INCLUDING CONTENTS option


SQL>
0
Comment
Question by:b7dba
  • 3
  • 2
6 Comments
 
LVL 76

Accepted Solution

by:
slightwv (䄆 Netminder) earned 500 total points
ID: 37756657
Error is self explainitory:
tablespace not empty, use INCLUDING CONTENTS option

drop tablespace EXAMPLE INCLUDING CONTENTS;

http://docs.oracle.com/cd/E11882_01/server.112/e26088/statements_9004.htm

also look into:  AND DATAFILES
0
 

Expert Comment

by:expert9
ID: 37756759
use below query to confirm that there are objects in this tablespace

select segment_name from dba_segments where tablespace_name='EXAMPLE';

This will confirms that a table has been created in the tablespace EXAMPLE.

so it is essential to drop the tablespace and the contents in it so to fix this problem do the following:-

drop tablespace EXAMPLE including contents and datafiles;

This will fixed the issue.

The option INCLUDING CONTENTS AND DATAFILES will removes the physical files.
0
 
LVL 76

Expert Comment

by:slightwv (䄆 Netminder)
ID: 37756790
expert9,

I see you are new to the site.  Welcome.  Please take some time to familiarize yourself with the site by reading through the Help section.

Please read through previous posts before posting so you do not post duplicate information.
0
 

Expert Comment

by:expert9
ID: 37756812
0
 

Expert Comment

by:expert9
ID: 37802627
well i believe there is alot of difference between in explaining things and duplicating things. client knows nothing thats what the expert exchange is about and experts have to provide solutions which can be understood by the client.......
any ways its ok zone advisor..
0

Featured Post

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Join & Write a Comment

Cursors in Oracle: A cursor is used to process individual rows returned by database system for a query. In oracle every SQL statement executed by the oracle server has a private area. This area contains information about the SQL statement and the…
I remember the day when someone asked me to create a user for an application developement. The user should be able to create views and materialized views and, so, I used the following syntax: (CODE) This way, I guessed, I would ensure that use…
This videos aims to give the viewer a basic demonstration of how a user can query current session information by using the SYS_CONTEXT function
This video shows how to recover a database from a user managed backup

744 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

11 Experts available now in Live!

Get 1:1 Help Now