Yes Im on Windows xp the script names and dir structure should be the
same though...
Here is buildall.sql
buildall.sql
spool \build.log
SET TERMOUT OFF
SET ECHO OFF
connect internal
@@build_db.sql
@C:\oracle\ora81\RDBMS\admin\catalog.sql
Which oracle version is your buildall.sql for? I just queried my 9i db and
got this:
SQL select TABLESPACE_NAME from dba_tablespaces;
TABLESPACE_NAME
--
SYSTEM
UNDOTBS1
TEMP
CWMLITE
DRSYS
EXAMPLE
INDX
ODM
TOOLS
USERS
XDB
Where is Undo tablespace part in your
%ORACLEHOME%\rdbms\admin\build.db is one of them check this script which
calls several others
bob
-Original Message-
Sent: Wednesday, October 08, 2003 5:39 PM
To: Multiple recipients of list ORACLE-L
installation)?
Hi:
I just installed Oracle 9.2.0.1.0 on our Solaris 9 box for the 1st
Hi:
I am on unix and I can not find the file you menetioned. Looks like your
box is Microsoft one.
essex$ pwd
/oracle/product/9.2.0.1.0/rdbms/admin
essex$ ls -l b*
b*: No such file or directory
Guang
On Wed, 8 Oct 2003, Bob Metelsky wrote:
%ORACLEHOME%\rdbms\admin\build.db is one of them
Hi,
There's no db creation scripts for 9i seed database,9i DBCA uses template
to create sample database.DBCA templates located in
$ORACLE_HOME/assistants/dbca/templates,they are a set of XML files.If you
want db creation scripts ,DBCA can be used to generate them.
Regards,
Zhai
On Wed, 08