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 many types of table in Oracle?
What is the difference between implicit index and explicit index?
What different of iner joint & outer joint with example
How to view the data files in the current database?
How to retrieve data from an explicit cursor?
What is the difference between formal parameters and actual parameters?
How many anonymous blocks can be defined?
What is the purpose of tables, private synonyms and public synonyms in Oracle?
How to delete multiple rows from a table in oracle?
How do I decide when to use right joins/left joins or inner joins or how to determine which table is on which side?
How to connect asp pages to oracle servers?
ex. one table is having 1 column with 10 records , then how to display all the values in row wise ?