Re: Help : Can not startup database after a tablespace is offline
Date: 1995/09/30
Message-ID: <jsharpe.13.000E6F9E_at_inforamp.net>#1/1
In article <44it92$2ln_at_fountain.mindlink.net> David Ng <David_Ng_at_mindlink.bc.ca> writes:
>Path: inforamp.net!uunet.ca!news.uunet.ca!torn!howland.reston.ans.net!news.sprintlink.net!in1.uu.net!van-bc!news.mindlink.net!news
>From: David Ng <David_Ng_at_mindlink.bc.ca>
>Newsgroups: comp.databases.oracle
>Subject: Help : Can not startup database after a tablespace is offline
>Date: 30 Sep 1995 07:57:22 GMT
>Organization: MIND LINK! - British Columbia, Canada
>Lines: 17
>Message-ID: <44it92$2ln_at_fountain.mindlink.net>
>NNTP-Posting-Host: line028.nwm.mindlink.net
>I have a urgent problem in the process of database reorganization.
>I have taken a tablepsace offline. After that, I can not startup the
>database again after I shut it down. The error message I got is that
>the datafiles of the offline tablespace can not be read. The STATUS
>column and ENABLE column of the datafiles are "OFFLINE" and "DISABLED".
> HP-UP V9.0
> Oracle DBMS V7.1.3
>Since I have to bring back the database by Monday, any advices are
>welcome.
>Thank you
Did you delete the files BEFORE setting the tablespace offline or before attempting to drop the Tablespace? If so, bad news.
J. Received on Sat Sep 30 1995 - 00:00:00 CET