• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 480
  • 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
 
HuaMinChenSystem managerCommented:
You cannot start DB backup and then drop tablespace.
0
 
walkerdbaAuthor Commented:
ok
0

Featured Post

The new generation of project management tools

With monday.com’s project management tool, you can see what everyone on your team is working in a single glance. Its intuitive dashboards are customizable, so you can create systems that work for you.

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