CREATE DATABASE DB1 LOGFILE GROUP 1 '/oracle/oradata/db1/redo1a.log&

Explain CREATE DATABASE syntax?

Question Posted / naresh

2 Answers
8606 Views
I also Faced
E-Mail Answers

Answer Posted / naresh

CREATE DATABASE DB1
LOGFILE
GROUP 1 '/oracle/oradata/db1/redo1a.log' size 5m,
GROUP 2 '/oracle/oradata/db2/redo2a.log' size 5m
TABLESPACE USERS datafile '/oracle/oradata/db1/system.dbf'
size 100m
AUTOEXTEND ON,
DEFAULT TEMPORARY TABLESPACE
tempfile '/oracle/oradata/db1/temp.dbf' size 10m AUTOEXTEND
ON,
TABLESPACE UNDO datafile '/oracle/oradata/db1/undo.dbf'
size 10m
CHARACTER SET US7ASCII
NATIONAL CHARACTER SET US16UTF16;

Is This Answer Correct ?

7 Yes

0 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

How to bind a cobol module to a given job? I am not able to understand this concept.Can anyone help me out as how to carry out this task?

2081

how can you process messages in order asynchronously?

967

. I have my backup RMAN script called "backup_rman.sh". I am on the target database. My catalog username/password is rman/rman. My catalog db is called rman. How would you run this shell script from the o/s such that it would run as a background process?

2439

Where do you find the default index fill factor and how to change it? : sql server DBA

1068

what are the differences of where and if in SAS?

2184

what is the diffrence between core dba and apps dba?

2561

How do you open a cluster administrator? : sql server DBA

1086

You have found corruption in a tablespace that contains static tables that are part of a database that is in NOARCHIVE log mode. How would you restore the tablespace without losing new data in the other tablespaces?

2796

I have A,B,C servers.i want to 3 servers jobs move to D server(target server)..how? note: i said that take the backup of msdb and restore to the target server..he said while restoring jobs replaced. what is the solution

2102

List out some of the requirements to setup a sql server failover cluster.? : sql server DBA

1254

Where would you look for errors from the database engine?

2843

Database crashes. Corruption is found scattered among the file system neither of your doing nor of Oracle's. What database recovery options are available? Database is in archive log mode.

2262

In which dictionary table or view would you look to determine at which time a snapshot or MVIEW last successfully refreshed?

2710

what is logical system in sap basis

1630

What are statistics, under what circumstances they go out of date, how do you update them?

2238