Another idea would be to set the SQLPATH variable in your registry (remember
if you do this to TAKE A BACKUP OF THE REGISTRY FIRST).
First of all map the network drive (it looks like you already have anyway)
so that it is assigned a drive letter (D:\ in your case), as you don't
really want to use the absolute path..
Open regedit or regedt32, and navigate to
HKEY_LOCAL_MACHINE/SOFTWARE/Oracle/<ORACLE_HOME>
and then either modify (if it is already there) or create a SQLPATH string,
with a value of:
D:\Oracle\Ora81\RDBMS\ADMIN\catalog.sql
Maybe this will work?
Mark
-----Original Message-----
Sent: 28 November 2001 16:23
To: 'Mark Leith'
Mark:
This was a typo and I tried it again and got the same error message.
The absolute full path name is: My Network Places\Entire Network\Microsoft
Windows Network\Tech
net\Proteus\ Oracle\Ora81\RDMS\ADMIN\catalog.sql The server name is
Proteus.
I have run scripts to generate tablespaces referencing the D:\ drive and
they worked OK.
Any ideas?
Ken
-----Original Message-----
Sent: Wednesday, November 28, 2001 10:20 AM
To: Ken Janusz
Subject: RE: Unable to run catalog.sql
Ken,
Taking a look at what you are trying to run, you have the path wrong:
@D:\Oracle\Ora81\RDMS\ADMIN\catalog.sql
should be:
@D:\Oracle\Ora81\RDBMS\ADMIN\catalog.sql
^
|
Will this work?
Mark
-----Original Message-----
Sent: 28 November 2001 13:16
To: 'Mark Leith'
Mark:
This is what I have tried at the SQL*Plus prompt.
nic13> @D:\Oracle\Ora81\RDMS\ADMIN\catalog.sql
SP2-0310: unable to open file "D:\Oracle\Ora81\RDMS\ADMIN\catalog.sql"
Still get the error. Would this have anything to do with Telnet working or
not? My Telnet connection between my client PC and the server doesn't work.
Thanks,
Ken
-----Original Message-----
From: Mark Leith [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, November 28, 2001 4:20 AM
To: Multiple recipients of list ORACLE-L
Subject: RE: Unable to run catalog.sql
It might be a PATH issue, try creating an entry in your PATH statement on
*your PC* that has the full path to the directory that holds catalog.sql.
-----Original Message-----
Sent: 27 November 2001 19:00
To: Multiple recipients of list ORACLE-L
I have tried to run catalog.sql from the sql*plus command line and keep
getting this error. sp2-0310 unable to open file "catalog.sql". I've use
the full path name with the same results. catalog.sql is on my PC and the
database is located on a server. I have run other commands from my client
machine with no problems.
What appears to be the problem?
TIA
Ken Janusz, CPIM
Database Conversion Lead
Sufficient System, Inc.
Minneapolis, MN
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Ken Janusz
INET: [EMAIL PROTECTED]
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
San Diego, California -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L (or the
name of mailing list you want to be removed from). You may also send the
HELP command for other information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Mark Leith
INET: [EMAIL PROTECTED]
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
San Diego, California -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L (or the
name of mailing list you want to be removed from). You may also send the
HELP command for other information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Mark Leith
INET: [EMAIL PROTECTED]
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
San Diego, California -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
