Oracle database creation

[oracle]

Hi,

I have installed oracle9i(9.1.0.1.0) in win2000 (single pc).

I want to create a new database manually .

If anyone willing to help me it will be a great
help for me .
mail me
ad_12c at yahoo.com

[Hans Forbrich]

oracle wrote:

have installed oracle9i(9.1.0.1.0) in win2000 (single pc).

I want to create a new database manually .

If anyone willing to help me it will be a great
help for me .
mail me
ad_12c at yahoo.com

http://otn.oracle.com/obe has a screen-shot based tutorial walking you
through this.

[oracle]

Hans Forbrich <fo******@yahoo.net> wrote in message news:<ITcIc.32631$eO.20618@edtnps89>...

oracle wrote:

have installed oracle9i(9.1.0.1.0) in win2000 (single pc).

I want to create a new database manually .

If anyone willing to help me it will be a great
help for me .
mail me
ad_12c at yahoo.com

http://otn.oracle.com/obe has a screen-shot based tutorial walking you
through this.

Hi,

I go there but did not find any .doc
I want to manually create the new database
without using Database Configuration Assistant.

[Hans Forbrich]

oracle wrote:

I go there but did not find any .doc
I want to manually create the new database
without using Database Configuration Assistant.

Sorry - misunderstood the question.

Go to the 'SQL Reference' manual in the http:/docs.oracle.com document
archives and look for the 'CREATE DATABASE' command.

It's a relatively complicated command which requires understanding of
system, temporary, rollback/undo, and data tablespaces, block sizes (and
related SGA impacts), as well as a number of other issues.

There are simply too many variations to give you any advice over the
newsgroup without detailed understanding of your needs. Which explains why
Oracle makes the DBCA available.

Note that most people who ask this question are using the SQL Server/Sybase
definition of 'Database'. Oracle's equivalent is 'SCHEMA'. Please verify
(at least for yourself) that you really need a new database and not just a
new schema.