cmd: Create Database

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 Received on Thu Aug 08 2002 - 11:32:08 CDT