• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 498
  • 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
 
HuaMin ChenSystem 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

Cloud Class® Course: C++ 11 Fundamentals

This course will introduce you to C++ 11 and teach you about syntax fundamentals.

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