How to create a new database?

Asked By Nina Hayes 0 points N/A Posted on - 04/06/2012

How to create a new database? Please give easy steps since I’m new to it. Your help will be much appreciated. Thanks!

• Status: Open
• Question Views: 1316
• Answer Count: 2
• Vote Up 0 Vote Down

• Answer Accepted: Yes
• Question Category: Oracle Database

Best Answer by Allen Kenneth

Go To Solution

Answered By Estillero State 5 points N/A #104768

How to create a new database?

Hi Nina,

You can use the CREATE DATABASE <database name> statement. But before that, you have few things to consider. You need to create a user account on the on the database for you to use when opening the connection. The user you are to create must have enough rights to create a database. You can use the Database Configuration Assistant (DBCA) which has a graphical user interface for creating Oracle databases. You can also create database manually using a script. 

Take a look at this web site to learn more about how to create Oracle databases.

https://docs.oracle.com/cd/B10501_01/server.920/a96521/create.htm

 

I hope it helps.

About Estillero State

Questions
7

Answers
70

Best Answers
7

• Vote Up 0 Vote Down

• Posted on - 04/19/2012
• Question Category: Oracle Database

Best Answer

Best Answer

Answered By Allen Kenneth 20 points N/A #104769

How to create a new database?

Hello Nina,

There are two steps for creating an Oracle database.
By using the DBCA (Database Configuration Assistant) and by using a CREATE statement to do it manually.
And most importantly, some facts are there which need your attention, like Oracle System ID (SID), Establishing admin authentication, SYSDBA, Instance etc.

So rather than stating all of them here, its more convenient  if you can learn more from the guide to Oracle Database Administration. You can understand everything as they are described in much simple methods 

Follow this link to the Oracle Database Administration Guide: https://docs.oracle.com/cd/B19306_01/server.102/b14231/create.htm

Hope you will get help out of this and learn everything.

About Allen Kenneth

Questions
1

Answers
100

Best Answers
74

• Vote Up 0 Vote Down

• Posted on - 12/12/2012
• Question Category: Oracle Database