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 |
How to convert raw data type into text in oracle? Explain
Explain oracle’s system global area (sga).
How are the index updates?
What are the uses of synonyms?
What are the Limitations of a CHECK Constraint ?
What is the quickest way to export a table to a flat file?
how to get the no employee in each department including the dept which has 0 employee
Explain joins in oracle?
what is difference between cartesian join & cross join even they give same result?
How to use fetch statement in a loop?
Whether any commands are used for months calculation? If so, what are they?
What is the sid in oracle?