Path: news.easynews.com!easynews!newshosting.com!news-xfer2.atl.newshosting.com!news-out.nuthinbutnews.com!propagator-sterling!news-in.nuthinbutnews.com!cyclone1.gnilink.net!spamfinder.gnilink.net!nwrddc03.gnilink.net.POSTED!53ab2750!not-for-mail From: "Gershon Kozokin" Newsgroups: comp.databases.oracle.misc Subject: cmd: Create Database Lines: 17 X-Priority: 3 X-MSMail-Priority: Normal X-Newsreader: Microsoft Outlook Express 6.00.2600.0000 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2600.0000 Message-ID: Date: Thu, 08 Aug 2002 16:32:08 GMT NNTP-Posting-Host: 162.84.223.74 X-Complaints-To: abuse@verizon.net X-Trace: nwrddc03.gnilink.net 1028824328 162.84.223.74 (Thu, 08 Aug 2002 12:32:08 EDT) NNTP-Posting-Date: Thu, 08 Aug 2002 12:32:08 EDT Xref: easynews comp.databases.oracle.misc:85321 X-Received-Date: Thu, 08 Aug 2002 09:29:13 MST (news.easynews.com) 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