| ib |
Posted: Sep 07, 2007 07:50:51 AM |
Total Post: 15
Joined: Aug, 2007
|
hi friends,
can anybody send the script for database creation.i need very urgent.if anyone have it pls send to my id (balamurugan.ib@gmail.com) |
|
|
 Mohammed Taj |
| Posted: Sep 08, 2007 12:58:15 AM |  |
|
Total Post: 694
Joined: Jul, 2007
|
http://dbataj.blogspot.com/search/label/Database%20Creation
|
|
|
|
|
| Navi |
| Posted: Sep 08, 2007 07:41:30 AM | |
|
Total Post: 60
Joined: Jun, 2007
|
Hi,
CREATE DATABASE DBPROD
LOGFILE
GROUP 1 ('c:\oracle\oradata\DBPROD\redo01.log') SIZE 100M,
GROUP 2 ('c:\oracle\oradata\DBPROD\redo02.log') SIZE 100M
MAXLOGFILES 5
MAXLOGMEMBERS 5
MAXLOGHISTORY 1
MAXDATAFILES 100
MAXINSTANCES 1
DATAFILE 'c:\oracle\oradata\DBPROD\system01.dbf' SIZE 325M
CHARACTER SET US7ASCII
This link may help you:-
http://download-east.oracle.com/docs/cd/B14117_01/server.101/b10739/create.htm
Regards,
Naveen
|
|
|
|
|
| nick |
| Posted: Sep 11, 2007 11:19:19 AM | |
|
Total Post: 30
Joined: Sep, 2007
|
create database ns1
logfile group 1 ('/ora/app/ns1/redo1.log') size 10M,
group 2 ('/ora/app/ns1/redo2.log') size 10M,
group 3 ('/ora/app/ns1/redo3.log') size 10M
character set WE8ISO8859P1
national character set utf8
datafile '/ora/app/ns1/system.dbf'
size 50M
autoextend on
next 10M maxsize unlimited
extent management local
sysaux datafile '/ora/app/ns1/sysaux.dbf'
size 10M
autoextend on
next 10M
maxsize unlimited
undo tablespace undo
datafile '/ora/app/ns1/undo.dbf'
size 10M
default temporary tablespace temp
tempfile '/ora/app/ns1/temp.dbf'
size 10M;
|
|
|
|
|
| Time Zone: EDT |
Send this thread to your friend |
