Re: Problem witch create database

Comments embedded
"KULJEET" <kuljeet_twtpl_at_hotmail.com> wrote in message news:febbed51.0308282354.7ba1bc1e_at_posting.google.com...
> try with this script
>
> create database MYNEW
> maxinstances 1
> maxloghistory 1
> maxlogfiles 5
> maxlogmembers 5
> maxdatafiles 100
> datafile 'D:\oracle\oradata\mydb\system01.dbf'
> size 325m reuse autoextend on next 10240k maxsize unlimited
> character set WE8MSWIN1252
> national character set AL16UTF16
> logfile group 1 ('d:\oracle\oradata\mydb\redo01.log') size 100m,
> group 2 ('d:\oracle\oradata\mydb\redo02.log') size 100m,
> group 3 ('d:\oracle\oradata\mydb\redo03.log') size 100m
> default temporary tablespace TEMP tempfile
'd:\oracle\oradata\mydb\temp01.dbf'
> extent management local uniform size 1m

what size do you want for your temporary tablespace? you don't specify

> undo tablespace UNDO_TS datafile 'd:\oracle\oradata\mydb\temp01.dbf'
> size 150m reuse autoextend on next 10240k maxsize unlimited
> ;

and now you are specifying that the undo tablespace will use the same file as the temporary tablespace (and using the reuse clause). I'd be interested to see what happens if you run this create database statement.

-- 
Niall Litchfield
Oracle DBA
Audit Commission UK