Re: Oracle 7.3 Questions

Try opening NOMOUNT and altering the database( or system, I can't remember which) to drop the tablespace thats causing problems...

John.Greco_at_dot.state.mn.us

"Laurie Kirsh" <lkirsh_at_itsc.org> wrote:

>just curious for a little more info....can you even mount the database?
>oh...and what OS are you running on?
>--
>+-------------------------------------+-----------------------------+
>| Laurie J. Kirsh | Oracle DBA/Design/Developer |
>| lkirsh_at_itsc.org | Integration Systems Analyst |
>| Lockheed Martin | ITSC project |
>| 301-982-1113 | College Park, Maryland |
>+-------------------------------------------------------------------+
>Opinions are mine and do not necessarily reflect those of
>Lockheed Martin Corporation.
>
>Chris Lueth <clueth_at_trinity1.com> wrote in article
><3384DE78.5410_at_trinity1.com>...
>> My database crashed last night with an internal error while creating a
>> new table from an existing one. The error message I get when I try to
>> run a shutdown is ORA 00600 with a 2141 in the first field. oerr says
>> to report this as a bug. Is this a known bug to anyone and, more
>> hopefully, a known solution?
>>
>> Now that the database is down fixing it has been circular. It needs
>> repairs but I can't open it to perform them. It there a way to open the
>> database and drop a tablespace when in this condition?
>>
>> Thanks,
>>
>> Chris
>>
>> Oracle user for 7+ months but feels like a lifetime
>>
Received on Fri May 23 1997 - 00:00:00 CDT