Wednesday, July 28, 2010

D:\oracle\product\10.1.0\Db_1>oradim -new -sid poker -intpwd poker -startmode M

create initpoker.ora file using notepad

control_files = (d:\oracle\databases\ora10\control01.ora,
d:\oracle\databases\ora10\control02.ora,
d:\oracle\databases\ora10\control03.ora)
undo_management = AUTO
undo_tablespace = UNDOTBS1
db_name = poker
db_block_size = 8192
sga_max_size = 1073741824 #one gig
sga_target = 1073741824 #one gig
put these parameter in the file and save.

sqlplus / as sysdba

startup nomount pfile='location/of/initpoker.ora';

QL>create database poker
logfile group 1 ('D:\oracle\databases\poker\redo1.log') size 10M,
group 2 ('D:\oracle\databases\poker\redo2.log') size 10M,
group 3 ('D:\oracle\databases\poker\redo3.log') size 10M
character set WE8ISO8859P1
national character set utf8
datafile 'D:\oracle\databases\poker\system.dbf'
size 50M
autoextend on
next 10M maxsize unlimited
extent management local
sysaux datafile 'D:\oracle\databases\poker\sysaux.dbf'
size 10M
autoextend on
next 10M
maxsize unlimited
undo tablespace UNDOTBS1
datafile 'D:\oracle\databases\poker\undo.dbf'
size 10M
default temporary tablespace temp
tempfile 'D:\oracle\databases\poker\temp.dbf'
size 10M;



SQL> @?/rdbms/admin/catalog.sql
SQL> @?/rdbms/admin/catproc.sql

1 comment:

  1. Thank you for making this site very interesting! Keep going! You're doing very well! theblackjack-tips

    ReplyDelete