Hi all,

I managed to corrupt my TEMP tablespace ... fortunately, this is a new
machine that we're rebuilding ...

I just want to know if following is the procedure that I have to follow to
recover from this problem:


1. Startup the database

2. Check which users are assigned this TEMP tablespace, i.e. from
DBA_USERS and note this down

3. Create a new TEMP tablespace

4. Assign the users from step 2 to use this new TEMP tablespace

5. Drop the corrupted TEMP tablespace

6. Re-create the corrupted TEMP tablespace with the REUSE DATAFILE
option

7. Re-assign the user to the re-created TEMP tablespace

8. Drop the TEMP tablespace created in step 3

9. At this stage, everything should be okay now ...

BTW, I can still do startup restrict or exclusive on Oracle9, right?



Oracle LazyDBA home page