-
CREATE Database Command
HI,
Oracle 9.2.0.3
UNIX AIX 5.2
I am having trouble with the 9i create database command.
I want to use the new locally managed tbsp for the system tablespace. I have tried several ways and still getting errors.
I want:
Local in all tbsp, no dictionary
uniform sizing
no auto extend
See below.
create database "$db"
maxinstances 2
maxlogfiles 32
maxlogmembers 4
maxloghistory 500
maxdatafiles 32000
datafile '/u09/oradata/ORACLE/prdgis02/system01.dbf' size 200M
extent management LOCAL uniform size 128k
character set UTF8
national character set UTF8
logfile group 1 ('/u10/oradata/ORACLE/prdgis02/redo01.log') size 250M,
group 2 ('/u10/oradata/ORACLE/prdgis02/redo02.log') size 250M,
group 3 ('/u10/oradata/ORACLE/prdgis02/redo03.log') size 250M
default temporary tablespace TEMP
tempfile '/u12/oradata/ORACLE/prdgis02/temp01.dbf' size 500M,
'/u12/oradata/ORACLE/prdgis02/temp02.dbf' size 500M,
'/u12/oradata/ORACLE/prdgis02/temp03.dbf' size 500M
extent management LOCAL uniform size 1024k
undo tablespace undotbs01
datafile '/u13/oradata/ORACLE/prdgis02/undotbs01_1.dbf' size 500M extent amangement LOCAL uniform size 1024k;
Last edited by kburrows; 12-19-2005 at 11:48 AM.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|