I did not know this was possible. How can I fire up the database
creation assistant once oracle is installed?
Thanks,
CC
Thomas Hesse wrote:
> Why don't you use the database assistant, store the create scripts and
> edit them ?
>
> Chuckster wrote:
>
>>
>> I have pieced together this script but it gives me ORA-30014 at line1.
>> Metalink wasn't too helpful. I am pretty solid with Oracle 8.1.7 but
>> some of the terminology in this script is new to me. I found this
>> script on google. (I merely changed the mount points and instance name)
>>
>> I start the script as follows:
>> $ORACLE_HOME/bin/sqlplus /nolog @create_database.sql
>>
>> Here is the script (create_database.sql):
>>
>> connect SYS/change_on_install as SYSDBA
>>
>> spool create_RHUGGA_database.log
>>
>> startup nomount
>>
>> SELECT 'START TIME: ' || TO_CHAR(sysdate, 'DD-MON-YYYY HH24:MI:SS') as
>> Start_Time
>> FROM dual;
>>
>> CREATE DATABASE "RHUGGA" NOARCHIVELOG
>> MAXLOGFILES 32
>> MAXLOGMEMBERS 5
>> MAXDATAFILES 600
>> MAXINSTANCES 10
>> MAXLOGHISTORY 1000
>> DATAFILE
>> '/u01/oradata/RHUGGA/system01.dbf' size 200M
>> REUSE
>> AUTOEXTEND ON NEXT 10M MAXSIZE UNLIMITED
>> DEFAULT TEMPORARY TABLESPACE temp
>> TEMPFILE '/u01/oradata/RHUGGA/temp01.dbf' SIZE 100M REUSE
>> EXTENT MANAGEMENT LOCAL UNIFORM SIZE 500K
>> UNDO TABLESPACE "UNDOTBS" DATAFILE
>> '/u01/oradata/RHUGGA/undotbs01.dbf' SIZE 100M
>> REUSE
>> AUTOEXTEND ON NEXT 5M MAXSIZE UNLIMITED
>> CHARACTER SET WE8ISO8859P1
>> NATIONAL CHARACTER SET UTF8
>> LOGFILE
>> GROUP 1
>> ('/u01/oradata/RHUGGA/redo_g01a.log',
>> '/u02/oradata/RHUGGA/redo_g01b.log',
>> '/u03/oradata/RHUGGA/redo_g01c.log') SIZE 5M,
>> GROUP 2
>> ( '/u01/oradata/RHUGGA/redo_g02a.log',
>> '/u02/oradata/RHUGGA/redo_g02b.log',
>> '/u03/oradata/RHUGGA/redo_g02c.log') SIZE 5M,
>> GROUP 3
>> ( '/u01/oradata/RHUGGA/redo_g03a.log',
>> '/u02/oradata/RHUGGA/redo_g03b.log',
>> '/u03/oradata/RHUGGA/redo_g03c.log') SIZE 5M
>> /
>>
>> <SNIP>
>>
>>
>>
>> -----------== Posted via Newsfeed.Com - Uncensored Usenet News
>> ==----------
>> http://www.newsfeed.com The #1 Newsgroup Service in the World!
>> -----= Over 100,000 Newsgroups - Unlimited Fast Downloads - 19 Servers
>> =-----
>
>
-----------== Posted via Newsfeed.Com - Uncensored Usenet News ==----------
http://www.newsfeed.com The #1 Newsgroup Service in the World!
-----= Over 100,000 Newsgroups - Unlimited Fast Downloads - 19 Servers =-----
Received on Wed Jul 31 2002 - 00:46:18 CDT
