creation of database manually

[md7983]

I want to create database manually on oracle 9i.can anyone help me

[nikhilraj]

I want to create database manually on oracle 9i.can anyone help me

hey if u r saying manually ( i havent seen oracle 9i)
normal way of creating table is
create table tablename( datatype1 fieldname1,data type2 fieldname2 etc);

[sonajain]

I want to create database manually on oracle 9i.can anyone help me

hi ,

step of manully database
1- in cdrive create a folder (any name xyz)
2- in that xyz folder make 6 folder
pfile,control,d ata,redo,bdump, udump
3-goto notpad
create pfile all parameter & save as "initxyz.or a" as all file
if u done no the parameter of pfile plz let me so i can send u.
4-go to cmd promet
set oracle_sid=xyz
oradim -new -sid xyz
sqlplus/nolog
conn as sysdba
(connet to idle instances)
startup nomount pfile='c:/xyz/pfile/initxyz.ora'
create database ( write all parameter)
then run scripts 1-catalog.sql 2- catproc.sql

know databnase is open fro work.
plz let me know reply asap
from
sona