Re: Tablespace created, file destroyed - HELP!
From: Adrian C D Smith <smithacd_at_bpchem.demon.co.uk>
Date: Wed, 22 Jun 1994 10:38:20 +0000
Message-ID: <146732873wnr_at_bpchem.demon.co.uk>
Date: Wed, 22 Jun 1994 10:38:20 +0000
Message-ID: <146732873wnr_at_bpchem.demon.co.uk>
Its been some time but I am pretty sure you can start the database under
sqldba
using:
startup nomount
connect internal
alter database mount
You can then set the tablespaces offline or drop them and then do
alter database open
to bring up the full database fully.
You probably want to shutdown-restart at this point.
( its been a long time since I have done this so if this does not work try doing without the alter database mount)
Adrian Smith Received on Wed Jun 22 1994 - 12:38:20 CEST