• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 488
  • Last Modified:

cannot drop

SQL> alter database begin backup;

Database altered.

SQL> drop tablespace app including contents and datafiles;
drop tablespace app including contents and datafiles
*
ERROR at line 1:
ORA-01150: cannot prevent writes - file 6 has online backup set
ORA-01110: data file 6: '/u01/app/oracle/oradata/orcl/app.dbf'


SQL>

Why I cannot drop the app tablespace?
0
walkerdba
Asked:
walkerdba
1 Solution
 
Seth SimmonsSr. Systems AdministratorCommented:
you can't drop it while the backup is set

alter tablespace app end backup;

try to drop again
0
 
Praveen Kumar ChandrashekatrDatabase Analysist Senior Commented:
As stated in previous post you cann't drop the tablespace when its in backup mode, so first end the backup and if you want to drop the tablespace then take it offline then try to drop the tablespace.

SQL>Alter database end backup;
SQL>Alter tablespace app offline;
SQL>drop tablespace app including contents and datafiles;
0
 
HuaMinChenBusiness AnalystCommented:
You cannot start DB backup and then drop tablespace.
0
 
walkerdbaAuthor Commented:
ok
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now