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 |
There are three tables : E : EID,ENAME D : DID,DNAME empdept : eid, did select the employees who doesn't belong to any dep
Explain the use of rows option in exp command.
What is oracle rowcount?
Why does for update in oracle 8 cause an ora-01002 error?
Can we call a trigger inside a function and function inside a trigger? Give example.
why dont we assign not null constraint as table level constraint.
What is a package in oracle?
How to delete a user account in oracle?
What are the varoius components of physical database structure of oracle database?
What is Segment Advisor in Oracle?
What is procedure overloading in oracle?
What is not equal to in oracle?