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 do I know if oracle is installed on windows?
What is a connect identifier?
What are the differences between interval year to month and interval day to second?
What is an Extent ?
What is the difference between Outer join and Full outer join?
How to use subqueries with the exists operator in oracle?
What is the relationship among database, tablespace and data file?
write a query to dispaly those name who is more than one in student table? example- in a student table sandeep kumar comes 4 times, rakesh kumar comes 2 times, ajit kumar comes 1 times so query will display sandeep kumar and rakesh kumar single times.
Explain what are the characteristics of data files?
12. Display the client name in upper case only and in lower case only.
For a field in a repeating frame, can the source come from the column which does not exist in the data group which forms the base for the frame ?
am completed mca2011 how get certification in oracle