Message-ID: <3D4779AA.3000503@networkcloud.com> Date: Tue, 30 Jul 2002 22:46:18 -0700 From: Chuckster User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:0.9.4.1) Gecko/20020508 Netscape6/6.2.3 X-Accept-Language: en-us MIME-Version: 1.0 Newsgroups: comp.databases.oracle.server To: Thomas Hesse Subject: Re: Help with database creation: Oracle 9.2.0 References: <3D473930.8000405@networkcloud.com> <3D47402F.4050503@team.xtra.co.nz.nospam> Content-Type: text/plain; charset=us-ascii; format=flowed Content-Transfer-Encoding: 7bit NNTP-Posting-Host: 127.0.0.1 Lines: 86 X-Authenticated-User: rhugga X-Comments: This message was posted through Newsfeeds.com - http://www.newsfeeds.com X-Comments2: IMPORTANT: newsfeeds.com does not condone, nor support, spam or any illegal or copyrighted postings. X-Report: Please report abuse to Organization: Posted Via Newsfeeds.com = SPEED+RETENTION+COMPLETION = http://www.newsfeeds.com Path: news.easynews.com!easynews!news-out.cwix.com!newsfeed.cwix.com!newsfeed.nyc.globix.net!news-out.nuthinbutnews.com!propagator-sterling!news-in.nuthinbutnews.com!corp-goliath.newsgroups.com!not-for-mail Xref: easynews comp.databases.oracle.server:156425 X-Received-Date: Tue, 30 Jul 2002 22:49:34 MST (news.easynews.com) 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 >> / >> >> >> >> >> >> -----------== 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 =-----