Path: news.easynews.com!easynews!newshosting.com!news-xfer2.atl.newshosting.com!news-out.nuthinbutnews.com!propagator-sterling!news-in.nuthinbutnews.com!telocity-west!TELOCITY!sn-xit-03!sn-xit-01!sn-post-02!sn-post-01!supernews.com!corp.supernews.com!not-for-mail
From: Sybrand Bakker <postbus@sybrandb.demon.nl>
Newsgroups: comp.databases.oracle.misc
Subject: Re: cmd: Create Database
Date: Thu, 08 Aug 2002 20:01:08 +0200
Organization: Posted via Supernews, http://www.supernews.com
Message-ID: <kdc5lukcko21mc7o7dpssbhbkdnrhql3ja@4ax.com>
Reply-To: postbus@sybrandb.demon-verwijderdit.nl
References: <c2x49.4797$5T5.3694@nwrddc03.gnilink.net>
X-Newsreader: Forte Agent 1.91/32.564
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
X-Complaints-To: newsabuse@supernews.com
Lines: 28
Xref: easynews comp.databases.oracle.misc:85331
X-Received-Date: Thu, 08 Aug 2002 10:57:33 MST (news.easynews.com)

On Thu, 08 Aug 2002 16:32:08 GMT, "Gershon Kozokin"
<vze43w86@verizon.net> wrote:

>Hi,
>In SQL*PLUS, Is there a way to view the path to Home directory
>($ORACLE_HOME) and modify the path if necessary?
>To be more clear let say, I want to create database with command line in
>SQL*PLUS
>Where the data files and control files and log file should reside on other
>drive then by default, where the software resides.
>Example:
>The software installed on C:\ and I want the database on H:\ (Other disk)
>What the syntax should be with command CREATE DATABASE?
>
>Thank you in advance, appreciate any information .
>
>Gershon
>
>
http://tahiti.oracle.com has the *full* syntax for *all* commands.
Please avoid the RTFM type of question.

Regards


Sybrand Bakker, Senior Oracle DBA

To reply remove -verwijderdit from my e-mail address