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 is the difference between dropping a database and taking a database offline? : sql server DBA
how can you initialize log miner?
Explain the difference between a FUNCTION, PROCEDURE and PACKAGE.
How would you extract DDL of a table without using a GUI tool?
Query processing is slow(eg select query)how will u solve that
In what script is "snap$" created? In what script is the "scott/tiger" schema created?
Why would you use sql agent? : sql server DBA
which background process invoke at the time of upgradation tell me???
what is ora 24313?what is the procedure to exclude that error?
how can you enable flashback feature?
What is the default fill factor value? : sql server DBA
. 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?
Database is hung. Old and new user connections alike hang on impact. What do you do? Your SYS SQLPLUS session IS able to connect.
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.
Does transparent data encryption provide encryption when transmitting data across network? : sql server DBA