Solved

tablespace

Posted on 2012-03-23
6
526 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.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
compre toata in where clue oracle 4 55
query in Oracle forms Builder 2 41
report returning null 21 79
help on oracle query 5 30
Truncate is a DDL Command where as Delete is a DML Command. Both will delete data from table, but what is the difference between these below statements truncate table <table_name> ?? delete from <table_name> ?? The first command cannot be …
Checking the Alert Log in AWS RDS Oracle can be a pain through their user interface.  I made a script to download the Alert Log, look for errors, and email me the trace files.  In this article I'll describe what I did and share my script.
Via a live example show how to connect to RMAN, make basic configuration settings changes and then take a backup of a demo database
This video shows how to set up a shell script to accept a positional parameter when called, pass that to a SQL script, accept the output from the statement back and then manipulate it in the Shell.

911 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

22 Experts available now in Live!

Get 1:1 Help Now