Re: Problem witch create database

From: KULJEET <kuljeet_twtpl_at_hotmail.com>
Date: 29 Aug 2003 00:54:47 -0700
Message-ID: <febbed51.0308282354.7ba1bc1e@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 undo tablespace UNDO_TS datafile 'd:\oracle\oradata\mydb\temp01.dbf'   size 150m reuse autoextend on next 10240k maxsize unlimited ;

-->or replace with this from u r temparary tablespace
default temporary tablespace TEMP tempfile 'd:\oracle\oradata\mydb\temp01.dbf'   extent management local uniform size 1m Received on Fri Aug 29 2003 - 02:54:47 CDT