Home » SQL & PL/SQL » SQL & PL/SQL » how to create database in oracle
how to create database in oracle [message #192696] Wed, 13 September 2006 05:10 Go to next message
koti209
Messages: 2
Registered: September 2006
Junior Member
Hi All,

Kindly let me know how to create Database in oracle....

if possible send me the sytex of query......

thanks in advance....
koti
Re: how to create database in oracle [message #192697 is a reply to message #192696] Wed, 13 September 2006 05:14 Go to previous messageGo to next message
Liza79
Messages: 74
Registered: September 2006
Member
create database db_name
user sys    identified by password_sys
user system identified by password_system
controlfile reuse
maxdatafiles 22
maxinstances  2
character set          we8iso8859p1
national character set utf8
set default bigfile tablespace
-- database logging clauses
logfile 
      group 1 ('c:\x\y\redo_1a.log', 'd:\x\y\redo_2a.log) size 512K,
      group 2 ('c:\x\y\redo_1b.log), 'd:'x\y\redo_2b.log) size 512K
maxlogfiles 3
maxlogmembers 7
maxloghistory 1000
archivelog
force logging
-- Tablespace Clauses
extent management local
datafile 'c:\foo\bar\system.dbf' size 300M [reuse] autoextend off
sysaux datafile 'c:\foo\bar\sysaux.dbf' size 100M [reuse] autoextend off
default           tablespace ts_data datafile 'c:\foo\bar\data.dbf' size 1M autoextend on�next 128K maxsize 2M extent management local
default temporary tablespace ts_temp tempfile 'c:\foo\bar\temp.dbf' size 2M autoextent off                     extent management local
undo tablespace ts_undo datafile 'c:\foo\bar\undo.dbf' size 2M autoextent off 
--
set time_zone = '-01:00';



Have a look on this page for details:
http://www.adp-gmbh.ch/ora/admin/creatingdbmanually.html

Liza
Re: how to create database in oracle [message #192724 is a reply to message #192696] Wed, 13 September 2006 06:22 Go to previous message
ebrian
Messages: 2794
Registered: April 2006
Senior Member
If this is your first time, you may want to use the Database Configuration Assistant (DBCA) to create the database and then review the scripts that it generates.

You don't mention what version of the database, but here are the details for 10g: Using DBCA to Create and Configure a Database
Previous Topic: sql features
Next Topic: error message
Goto Forum:
  


Current Time: Fri Dec 02 20:40:34 CST 2016

Total time taken to generate the page: 0.13476 seconds