|
-
Tim,
Thanks for your responce, this is that I have in my init.ora
undo_management = auto
undo_tablespace = undotbs
undo_retention = 600
and below is the sample of my create scripts:
create database MYTEST
controlfile reuse
maxdatafiles 1022
maxlogfiles 32
maxlogmembers 5
maxinstances 10
character set "WE8ISO8859P1"
datafile 'C:\ORADATA\MYTEST\system01.dbf' size 400m
logfile ('C:\ORADATA\MYTEST\log1MYTEST_A.rdo',
'C:\ORADATA\MYTEST\log1MYTEST_B.rdo') size 10M,
('C:\ORADATA\MYTEST\log2MYTEST_A.rdo',
'C:\ORADATA\MYTEST\log2MYTEST_B.rdo') size 10M,
('C:\ORADATA\MYTEST\log3MYTEST_A.rdo',
'C:\ORADATA\MYTEST\log3MYTEST_B.rdo') size 10M
UNDO TABLESPACE undotbs_01 DATAFILE 'C:\ORADATA\MYTEST\undo0101.dbf';
I got the foloowing error:
create database MYTEST
*
ERROR at line 1:
ORA-01092: ORACLE instance terminated. Disconnection forced
could you please let me know what I did wrong ???
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
|