Database Reference
In-Depth Information
Remember that you cannot drop SYSTEM tablespace. As the
tables related to data dictionary and dynamic performance Views
have to be up all the times during normal Oracle operation.
If the tablespace that you are deleting has referential integrity
(Primary/Foreign Key relationship) constraints with the objects
in other tablespace then include the clause CASCADE
CONTRAINS as shown below.
DROP TABLESPACE users INCLUDING CONTENTS
CASCADE CONSTRAINTS;
Now let's see how to change the name and location of all the
data files belonging to a tablespace. It's always recommended to
take full backup of the database before making any change
pertaining to the structure of the database.
It's better to have the hard copy of the location and names of
data files associated with the tablespace in front of you by using
the DBA_DATA_FILES view. This view will give you the name
of the tablespaces and the associated data files.
Changing The Name/Location Of Complete Tablespace or
Data File(s)
If the tablespace is comprised of two data files you can change
the name and location of one data file or all the data files.
Changing the name and/or location of all the data files associated
with the tablespace means that you are changing the name and/or
location of complete tablespace.
Step 1: Take the tablespace offline
ALTER TABLESPACE payroll OFFLINE;
OR
Search WWH ::
Custom Search