Re: If I delete the INSTANCE, will it affect the database?

On Sat, 18 Jul 1998 21:17:31 -0400, JHY <jhy_at_earthling.net> wrote:
>
>So, getting back to the original question, an instance can be deleted without
>affecting a database. The original posters statement: "I have two databases
>under ORCL instance" doesn't make a lot of sense I'm afraid.

It may make sense if the original poster is using a non-oracle definition of databases, which we may call schemata or files. Otherwise, some time in the Concepts manuals might be called for.

>
>> ashesh48_at_my-dejanews.com wrote in message
>> <6olpsd$l06$1_at_nnrp1.dejanews.com>...
>> >Hi AIl, I ran into a problem. Due to problems in CTL1ORCL.ORA file
>> >(sid=ORCL) I am not able to start the Instance eventhoguh services are
>> >running. I have two databases under ORCL instance. My question is Will it
>> >affect the Database if I delete the Instance? Will it delete the database
>> >also? OR is there any way that I can recreate only CTL1ORCL.ORA for that
>> >instance???Thanks in advance for any help.Ashesh
>> >
>> >-----== Posted via Deja News, The Leader in Internet Discussion ==-----
>> >http://www.dejanews.com/rg_mkgrp.xp Create Your Own Free Member Forum
>
>
>

--
These opinions are my own and not necessarily those of Information Quest or Pebble In The Sky http://www.informationquest.com mailto:jgarry@nospameiq.com http://ourworld.compuserve.com/homepages/joel_garry Remove nospam to reply. mailto:joel_garry_at_compuserve.nospam.com "See your DBA?" I AM the @#%*& DBA! Received on Wed Jul 22 1998 - 12:33:59 CDT