Deleting a tablespace
From: Shirley <shirley_at_odin.mda.uth.tmc.edu>
Date: 15 Aug 1994 21:38:22 GMT
Message-ID: <32on8e$e8a_at_oac4.hsc.uth.tmc.edu>
Date: 15 Aug 1994 21:38:22 GMT
Message-ID: <32on8e$e8a_at_oac4.hsc.uth.tmc.edu>
I need to drop a tablespace, but before I do it,
I would like to make sure that I am doing it correctly.
Here is the list of steps:
with the cascade constraints option on
1. Bring the tablespace offline
2. Drop all tables residing in the tablespace
3. Drop all users associated with the tablespace
4. Drop the tablespace including contents
5. Alter the database to bring the datafile offline
6. Delete the data file
Thank you very much for your help. Received on Mon Aug 15 1994 - 23:38:22 CEST