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 |
What privilege is needed for a user to create tables in oracle?
What is raw datatype in oracle?
after installatio of ORACLE 8i, work properly, but after restarting the system, it throw an error ORA 01034: ORACLE not availble
various types of hints and their usage
Why do I get unexpected characters from 8-bit character sets in weblogic jdriver for oracle?
4. Using a set operator, display the creditor number of all creditors who have ever been paid.
how to truncate date and get only time part 9:20:00
Explain about integrity constraint?
Will the Optimizer always use COST-based approach if OPTIMIZER_MODE is set to "Cost"?
Why is oracle database so popular?
Explain enable novalidate constraint.
What is a cursor and what are the steps need to be taken?