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
How do you open a cluster administrator? : sql server DBA
What types of replication are supported in sql server? : sql server DBA
What purpose does the model database server? : sql server DBA
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.
internal architecture
What are the different types of database compression introduced in sql server 2008? : sql server DBA
What are the new features in sql server 2005 when compared to sql server 2000? : sql server DBA
how can you implement fine-grained auditing?
Define the SGA and: How you would configure SGA for a mid-sized OLTP environment? What is involved in tuning the SGA?
what is grd?
what is ora 24313?what is the procedure to exclude that error?
How to craeate the New Database Schema in Oracle and mysql? Please tell me with Example?
What are the different types of indexes available in sql server? : sql server DBA
You have 4 instances running on the same UNIX box. How can you determine which shared memory and semaphores are associated with which instance?
When setting replication, can you have distributor on sql server 2005, publisher on sql server 2008? : sql server DBA