What happens when we drop tablespace?
After the tablespace has been dropped, these users cannot allocate space for objects or sort areas in the tablespace. You can reassign users new default and temporary tablespaces with the ALTER USER statement.
How do I force drop tablespace?
Introduction to Oracle DROP TABLESPACE statement First, specify the name of the tablespace that you want to drop after the DROP TABLESPACE keywords. Second, use the INCLUDE CONTENTS to delete all contents of the tablespace. If the tablespace has any objects, you must use this option to remove the tablespace.
What does SYSAUX tablespace do in Oracle 11g?
The SYSAUX tablespace in Oracle Database 11g is an auxiliary tablespace to the SYSTEM tablespace. As an auxiliary tablespace, the SYSAUX tablespace is intended for storing LOB (large object) data such as graphics and videos, as well as information that is rarely accessed and thus better suited for this “secondary storage.”
Can you alter the table space in SYSAUX?
Using SYSAUX DATAFILE clause in the CREATE DATABASE statement you can specify only datafile attributes in SYSAUX tablespace. 2. You can not alter attributes like (PERMANENT, READ WRITE,EXTENT MANAGEMENT LOCAL,SEGMENT SPACE MANAGEMENT AUTO) with an ALTER TABLESPACE statement 3.
Why do I have a SYSAUX table in my database?
The SYSAUX tablespace was installed as an auxiliary tablespace to the SYSTEM tablespace when you created your database. The SYSAUX tablespace is occupied by a number of database components, The SYSAUX tablespace is occupied by a number of database components.
What happens when you drop a table in Oracle?
Any objects that were previously dropped from the tablespace and moved to the recycle bin are purged from the recycle bin. Oracle Database removes from the data dictionary all metadata about the tablespace and all datafiles and tempfiles in the tablespace.