Re: Create new 8/8i Instance/database on remote NT Server using ORADIM?

Please read the Oracle Concepts Manual before you start doing this. I know it is not customary to read manuals among persons exposed to sqlserver, but in Oracle you won't get anywhere without reading, and you also can't rely on the newsgroups to answer your questions.

Just for now: A database in Sqlserver is not the same as a database in Oracle. A database in sqlserver is a schema in Oracle. Creating a database without user intervention is *extreemly* ill-advised, and one of the safest ways to hell as an instance needs at least 64 M of memory.

Just to be sure : oradim will NOT work remotely, luckily.

Regards,

Sybrand Bakker, Oracle DBA

<alastair_cameron_at_my-deja.com> wrote in message news:91l22v$i75$1_at_nnrp1.deja.com...
> Hello.
>
> Oracle 8/8i for Windows NT:
>
> I'd like to create a new oracle instance & database on either a local
> or remote NT Server. I'm new to Oracle (coming from SQL Server where
> this kind of thing is easy).
>
> I want to be able to, from a single NT Server, create new Oracle
> instance & database on other NT Servers that have Oracle installed. I'd
> like to be able to do this with no user intervention (all from command
> line with parameters if possible). ORADIM looks like the tool to create
> a new instance, but does it work remotely?
>
> I have a large DDL SQL file with the CREATE DATABASE/CREATE TABLE/etc
> commands to create the database. Presumably I can simply execute this
> script after the instance has been created by using SQL*Plus to connect
> to the instance with command line parameters to run the script?
>
> Thanks.
>
> Alastair
>
>
> Sent via Deja.com
> http://www.deja.com/
Received on Mon Dec 18 2000 - 17:56:17 CET