-
I am trying to setup intermedia text in my database .When I ran the dr0inst.sql .I got this error .
PROMPT ============== ConText Database Objects Installation ==============
*
ORA-00900: invalid SQL statement
MGR-00110: illegal SET option
'USERISCTXSYS'
--------------
User is CTXSYS
1 row selected.
MGR-00110: illegal SET option
whenever sqlerror continue
*
ORA-00900: invalid SQL statement
PROMPT ... creating tables and Oracle object types
*
ORA-00900: invalid SQL statement
Now I am trying to run the statement one by one ...I am trying to dr0lib.sql what should be the value that I should specify at ctxx_location ...
PROMPT ... creating safe callout library
define ctxx_location = "&1"
@@dr0lib.sql
-
Do not try to run the InterMedia scripts from svrmgrl. It does not understand SQL*Plus commands (SET, PROMPT, etc). It should be in the docs how to do that.
Here is why you are getting errors:
SVRMGR> prompt --------
2>
3>
4>
5>
6> /
prompt --------
*
ORA-00900: invalid SQL statement
SVRMGR> exit
Server Manager complete.
/home1/oracle $ sqlplus /
SQL*Plus: Release 8.1.6.0.0 - Production on Thu May 23 12:05:05 2002
(c) Copyright 1999 Oracle Corporation. All rights reserved.
Connected to:
Oracle8i Enterprise Edition Release 8.1.7.0.0 - Production
With the Partitioning option
JServer Release 8.1.7.0.0 - Production
SQL> prompt ---------
> /
-------- /
Hope that helps,
:)
--clio_usa
Senior Oracle DBA
Oracle DBA forums at:
http://www.dbaclick.com/cgi-bin/ib3/ikonboard.cgi
----------------------------------------------------------