how to create a new database in oracle?

Answer Posted / nathahar anees

MANUAL CREATION:
CREATE APROPRIATE FOLDERS IN THE CORRESPONDING LOCATION AND
CREATE PFILE..
COME TO COMMAND PROMPT CREATE NEW SID USING ORANEW COMMAND
AND START INSTANCE IN NOMOUNT STAGAGE AND CREATE A DATABASE
COMMAND FOR DATABASE CREATION.

sql :> CREATE DATABASE <DATABASE NAME> DATAFILE....

AND RUN CATALOG AND CATPROC SCRIPTS

Is This Answer Correct ?    1 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How to bring a tablespace offline?

532


How do I know if oracle is installed on windows?

480


Which environment variables are absolutely critical in order to run the OUI?

1642


Explain a segment?

606


How would you configure your networking files to connect to a database by the name of DSS which resides in domain icallinc.com?

1461






How can we view last record added to a table?

590


Explain the use of indexes option in exp command.

586


How to define a record variable to store a table row?

573


Other than making use of the statspack utility, what would you check when you are monitoring or running a health check on an Oracle 8i or 9i database?

1496


How to create lov dynamically at runtime & attach to text field?

653


Does oracle partitioning improve performance?

541


How to increment dates by 1 in oracle?

553


What is the use of oracle?

541


What privilege is needed for a user to insert rows to tables in another schema?

550


How to join two tables in a single query using oracle?

560