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
What are the different types of database compression introduced in sql server 2008? : sql server DBA
when does an alert gets signaled?
What are the differences in clustering in sql server 2005 and 2008 or 2008 r2? : sql server DBA
how can you schedule a job in database?
You have 4 instances running on the same UNIX box. How can you determine which shared memory and semaphores are associated with which instance?
What are the different types of indexes available in sql server? : sql server DBA
What would you do with an "in-doubt" distributed transaction?
What is the difference between dropping a database and taking a database offline? : sql server DBA
List out some of the requirements to setup a sql server failover cluster.? : sql server DBA
currently iam working in mnc as a oracleappsdba,please send the EXPERIENCE RESUME those who r worked as a oracle apps dba
What is the default port no on which sql server listens? : sql server DBA
What are the different ways you can create databases in sql server? : sql server DBA
What are the operating modes in which database mirroring runs? : sql server DBA
what functionality does oracle provide to secure sensitive information?
What types of replication are supported in sql server? : sql server DBA