oracle database

[shankarn]

hi
i am new to oracle database how to create database in oracle 9i a sample code would be very helpful

[Shuja Ali]

Documentation that comes with Oracle should be more than enough to start. Here is a link that may help you
http://download.oracle.com/docs/cd/B19306_01/server.102/b14200/statements_5004.htm

[davide++]

Hi all

The term "database" in Oracle means several things...
Do you want create a database instance or an user on an existing database instance?
Creating a database instance is a quite complex task, that usually is done by DBAs; with the newest release of Oracle there's a visual tool, called dbca, that helps you to create the instance: it's a wizard, and generates the scripts; you can find it in \bin directory of $ORACLE_HOME.
Creating an user is very simple: run the CREATE USER command from an user (of instance) that have the DBA rights (for example SYSTEM).

As you see in the few rows above, there are many things you need to know; if you're new with Oracle, you should read the documetation before starting these activities.