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 is the difference between INNER JOIN, LEFT JOIN, RIGHT JOIN, and FULL JOIN?
Explain about integrity constraint?
difference between truncate and delete ,drop?
how to convert .db (extention) database file into .dmp (extention ) for oracle database ?
What is a Shared SQL pool ?
In Oracle 9i what does "i" Stands for?
Explain the use of show option in imp command.
What is the difference between sharding and partitioning?
In Oracle Clinical 4.5.0, can the VIEW_TEMPLATE_ID column in DATA_EXTRACT_VIEWS table contain NULL value?
Table1- have two column filename data AFGDFD-20112011 hi how r u bsdasd-23042011 name shoud be in bold Now i want output like filename data AFGDFD hi how r u bsdasd name shoud be in bold Kindly answer this
How can you use check constraints for self referential integrity?
How to create a server parameter file?