<div>
you can't drop it while the backup is set<br />
<br />
<b>alter tablespace app end backup;</b><br />
<br />
try to drop again
</div>


you can't drop it while the backup is set

alter tablespace app end backup;

try to drop again

<div>
You cannot start DB backup and then drop tablespace.
</div>


You cannot start DB backup and then drop tablespace.

<div>
<div class="content wysiwyg-content">
SQL&gt; alter database begin backup;<br />
<br />
Database altered.<br />
<br />
SQL&gt; drop tablespace app including contents and datafiles;<br />
drop tablespace app including contents and datafiles<br />
*<br />
ERROR at line 1:<br />
ORA-01150: cannot prevent writes - file 6 has online backup set<br />
ORA-01110: data file 6: '/u01/app/oracle/oradata/o<wbr />rcl/app.db<wbr />f'<br />
<br />
<br />
SQL&gt; <br />
<br />
Why I cannot drop the app tablespace?
</div>
</div>


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?

cannot drop

Oracle is an object-relational database management system. It supports a large number of languages and application development frameworks. Its primary languages are SQL, PL/SQL and Java, but it also includes support for C and C++. Oracle also has its own enterprise modules and application server software.