How to create database in exisiting ..

[Ramana.Sv]

Hi, i have HP_UX system in this we have oracle 10G "myDB" in thsi different schemas is there, i want create another database in this can you plese help me in this regard.


Thanks

[PAVIC Thierry]

You can use the graphical tool dbca
you need a X-Windows on you PC - make following command on oracle accompt
export DISPLAY=YourIPAdrss:0.0

test with an xclock
if it's ok launch dbca

the other way is in using a shell script :
Here is some extract

ORACLE_SID=MyNewDataBaseName
NLS_LANG=.WE8ISO8859P15

export ORACLE_SID NLS_LANG

DISK0=/oracle/oradata
DISK1=/oracle/oradata

sqlplus "/ as sysdba" <spool $ORACLE_BASE/admin/$ORACLE_SID/scripts/createdb_1_$ORACLE_SID
set echo on
set pause off

shutdown abort

startup nomount
ALTER SESSION SET SORT_AREA_SIZE=10485760;

alter system set DB_CREATE_ONLINE_LOG_DEST_1='$DISK0';
alter system set db_create_file_dest='$DISK1';

CREATE DATABASE $ORACLE_SID MAXINSTANCES 3
MAXLOGHISTORY 30
MAXLOGFILES 32
MAXLOGMEMBERS 3
MAXDATAFILES 254
NOARCHIVELOG
DATAFILE SIZE 500M AUTOEXTEND OFF,
SIZE 500M AUTOEXTEND OFF,
SIZE 500M AUTOEXTEND OFF,
SIZE 500M AUTOEXTEND OFF,
SIZE 500M AUTOEXTEND OFF,
SIZE 500M AUTOEXTEND OFF
EXTENT MANAGEMENT LOCAL
SYSAUX DATAFILE
SIZE 100M AUTOEXTEND ON NEXT 100M MAXSIZE 500M
DEFAULT TEMPORARY TABLESPACE TEMPPROV TEMPFILE
SIZE 50M AUTOEXTEND ON NEXT 100M MAXSIZE 2000M
EXTENT MANAGEMENT LOCAL UNIFORM SIZE 1M
UNDO TABLESPACE UNDOPROV DATAFILE
SIZE 50M AUTOEXTEND ON NEXT 100M MAXSIZE 2000M
CHARACTER SET WE8ISO8859P15 ( This one is for France - check the good one for you)
LOGFILE GROUP 1 SIZE 30M,
GROUP 2 SIZE 30M,
GROUP 3 SIZE 30M,
GROUP 4 SIZE 30M,
GROUP 5 SIZE 30M,
GROUP 6 SIZE 30M,
GROUP 7 SIZE 30M,
GROUP 8 SIZE 30M,
GROUP 9 SIZE 30M,
GROUP 10 SIZE 30M
USER SYS IDENTIFIED BY sysman
USER SYSTEM IDENTIFIED BY manager;

CREATE SPFILE FROM PFILE;
ALTER SYSTEM SET UNDO_RETENTION = 0 SCOPE=MEMORY;
ALTER SYSTEM SET UNDO_TABLESPACE = UNDOPROV SCOPE=MEMORY;