469,951 Members | 2,559 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,951 developers. It's quick & easy.

Oracle database creation

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
Jul 19 '05 #1
3 3588
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.
Jul 19 '05 #2
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.
Jul 19 '05 #3
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.
Jul 19 '05 #4

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

11 posts views Thread by Philip D Heady | last post: by
reply views Thread by Cherrish Vaidiyan | last post: by
13 posts views Thread by BigDaDDY | last post: by
4 posts views Thread by BookerW | last post: by
3 posts views Thread by oracle | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.