Re: Can I create a database via oracle client?

I wonder how thorough the DROP DATABASE command is in 10g? For example, does it drop the init.ora file if you have one as it drops the spfile? Does it delete directories and the password file as well?

If the directory structures weren't deleted and the init.ora file remained then maybe you could issue the CREATE DATABASE command. Someone may have a use for that?

Would be interesting to find out.

"Goran" <goran99_remove_at_yahoo.com> wrote in message news:cju49c$rg8$1_at_fegnews.vip.hr...
>
> "Sybrand Bakker" <sybrandb_at_hccnet.nl> wrote in message
> news:9uo4m09300nkomaim2jvqmebcnpkl337gq_at_4ax.com...
>> On Tue, 05 Oct 2004 10:38:09 +0200, Markus Innerebner
>> <markusin_at_yahoo.de> wrote:
>>
>>>Dear collegs,
>>>
>>>I want to know, if there is a way to create a database with sqlplus via
>>>oracle client. I realized the problem, that for the connection to the
>>>server it is mandatory the connectionString(hoststring) that contains an
>>>SID.
>>>That meens, that without an existing database, I am not able to get a
>>>connection to the oracle server via sqlplus.
>>>
>>>Is there a way, that I can do it.
>>>I would not do it with DBCA, because this should be done via a sql
>>>script.
>>>
>>>thanks
>>>
>>>best regards Markus
>>
>> Obviously using a connection string won't work. It won't work because
>> you will need to have an instance, and a listener listening for that
>> instance.
>> The only way is to do it in sql*plus is *locally* *on the server* with
>> *ORACLE_SID* set.
>
> Actually, you don't need an instance nor a database to connect to db
> server; you need to have installation of oracle software, a listener for a
> future instance, proper init and password files and *dump directories
> created.
> You can connect "sys/pwd_at_xxx as sysdba" (listener starts dedicated server
> process), start an instance (startup nomount), create database etc... as
> if you were "on" the machine.
>
> Regards...
>
>
Received on Thu Oct 07 2004 - 02:15:55 CDT