how to create a new database in oracle?
Answers were Sorted based on User's Feedback
Answer / sachin
Hey Guies,
Please do not put a wrong answer.. Since other seeking for
info getting the wrong answer.
| Is This Answer Correct ? | 9 Yes | 0 No |
Answer / 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 |
Answer / shrikant jadhav
create table emp(id number(12),name varchar(12));
| Is This Answer Correct ? | 3 Yes | 20 No |
Why required to run root.sh at the time of installation and what exactly it will do
What WHERE CURRENT OF clause does in a cursor?
What is mean by Program Global Area (PGA) ?
How to call a stored function in oracle?
Explain about the analyze command in oracle?
How to commit the current transaction in oracle?
what is the syntax of ALTER command?
definition of cluster and non-clustered index?
Explain enable novalidate constraint.
Can we create more than one constraint to column ?
How to load data through external tables?
how do we code triggers , store procedure , Performance tuning and indexing in a Java Project? Pls kindly get me the perfect answer with the code for each....thank you in advance............pls any body kindly help me soon as possible....