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

Explain CREATE DATABASE syntax?

Question Posted / naresh

2 Answers
8585 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

What is the default port no on which sql server listens? : sql server DBA

1126

i have 10gp file.now i need store in database..but database have only 7gb memory only..how do u store the file ?

2043

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

2087

when does an alert gets signaled?

1023

what is ora 24313?what is the procedure to exclude that error?

2552

What is a correlated sub-query? : sql server DBA

1057

What are the different types of indexes available in sql server? : sql server DBA

1167

What is transparent data encryption? : sql server DBA

1171

what is a crs resource?

1146

Draft one mock email requesting your non-technical management grant you downtime to (provide justification where applicable) complete the following tasks: (1) Generate statistics on a large table; (2) Generate an RDA – if you don't know what an RDA is please say so. (3) Rename datafiles.

2155

You have 4 instances running on the same UNIX box. How can you determine which shared memory and semaphores are associated with which instance?

4414

What is fill factor? : sql server DBA

1228

What are the high-availability solutions in sql server and differentiate them briefly? : sql server DBA

1022

Where would you look for errors from the database engine?

2833

What spfile/init.ora file parameter exists to force the CBO to make the execution path of a given statement use an index, even if the index scan may appear to be calculated as more costly?

2656