However, this workaround does not remove the datafile from tablespace nor delete the file physically, but it reduce the risk as no data will be truncated as only empty blocks are reduced. It simply makes it unusable and takes up almost close to no disk space. To resize a datafile, use the following query:. Previous Next. You May Also Interested In:. This example demonstrates dropping an undo tablespace. This example shows how to drop an NDB tablespace myts having a data file named mydata Data Definition Statements.
Atomic Data Definition Statement Support. LIKE Statement. Silent Column Specification Changes. Secondary Indexes and Generated Columns.
Data Manipulation Statements. Parenthesized Query Expressions. The Subquery as Scalar Operand. Comparisons Using Subqueries. Restrictions on Subqueries. Transactional and Locking Statements. Statements That Cause an Implicit Commit. The database also automatically drops from the operating system any Oracle-managed data files and temp files in the tablespace.
You cannot use this statement to drop a tablespace group. However, if tablespace is the only tablespace in a tablespace group, then Oracle Database removes the tablespace group from the data dictionary as well. Restrictions on Dropping Tablespaces Dropping tablespaces is subject to the following restrictions:. You cannot drop a tablespace that contains a domain index or any objects created by a domain index. You cannot drop an undo tablespace if it is being used by any instance or if it contains any undo data needed to roll back uncommitted transactions.
You cannot drop a tablespace that has been designated as the default tablespace for the database. You must first reassign another tablespace as the default tablespace and then drop the old default tablespace. You cannot drop a temporary tablespace if it is part of the database default temporary tablespace group. You must first remove the tablespace from the database default temporary tablespace group and then drop it. You cannot drop a temporary tablespace if it contains segments that are in use by existing sessions.
0コメント