new database create command

Microsoft Windows XP [Version 5.1.2600]
(C) Copyright 1985-2001 Microsoft Corp.

C:\Documents and Settings\tinku>cd\

C:\>oradim -new -sid kumar -intpwd mysys -startmode a -pfile 'c:\oracle\admin\ku
mar\init.ora'

C:\>set oracle_sid=kumar

C:\>sqlplus /nolog

SQL*Plus: Release 9.2.0.1.0 - Production on Fri Jan 23 23:28:04 2004

Copyright (c) 1982, 2002, Oracle Corporation.  All rights reserved.

SQL> conn /as sysdba;
Connected to an idle instance.
SQL> startup nomount pfile='c:\oracle\admin\kumar\pfile\init.ora';
ORACLE instance started.

Total System Global Area  135338868 bytes
Fixed Size                   453492 bytes
Variable Size             109051904 bytes
Database Buffers           25165824 bytes
Redo Buffers                 667648 bytes
SQL> create database kumar
  2  controlfile reuse
  3  logfile
  4  group 1 ('c:\oracle\oradata\kumar\redo01.log') size 50m,
  5  group 2 ('c:\oracle\oradata\kumar\redo02.log') size 50m,
  6  group 3 ('c:\oracle\oradata\kumar\redo03.log') size 50m
  7  maxlogfiles 5
  8  maxlogmembers 5
  9  maxloghistory 1
 10  maxdatafiles 50
 11  maxinstances 1
 12  noarchivelog
 13  datafile 'c:\oracle\oradata\kumar\system01.dbf' size 400m
 14  default temporary tablespace temp tempfile 'c:\oracle\oradata\kumar\temp01.
temp' size 100m
 15  undo tablespace undotbs1 datafile 'c:\oracle\oradata\kumar\undotbs01.dbf' s
ize 100m;

Database created.

SQL>
SQL> @ 'e:\oracle\ora92\rdbms\admin\catalog.sql';


Comment created.


Commit complete.


PL/SQL procedure successfully completed.

SQL> @ 'e:\oracle\ora92\rdbms\admin\catproc.sql';