Re: Deleting a tablespace
Date: Tue, 16 Aug 1994 11:56:19 GMT
Message-ID: <X5MRBFYD_at_math.fu-berlin.de>
In article <32on8e$e8a_at_oac4.hsc.uth.tmc.edu>, Shirley <shirley_at_odin.mda.uth.tmc.edu> writes:
>
>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:
>1. Bring the tablespace offline
>2. Drop all tables residing in the tablespace
> with the cascade constraints option on
>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.
First of all, which version of Oracle do you use? Second, info on your platform may be handy too.
- OK
- Not necessary, but some DBA's do that in Oracle 6. Use: drop tablespace <name> including contents;
- Not necessary unless these users are not allowed access anymore.
- We did that in step 2)
- No.
- Yes.
Cheers,
Fred Wiersma
wiersma_at_tfdl.agro.nl
Received on Tue Aug 16 1994 - 13:56:19 CEST