DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Hybrid View

  1. #1
    Join Date
    Sep 2000
    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
    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"

  2. #2
    Join Date
    May 2002
    California, USA


    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 --------
    6> /
    prompt --------
    ORA-00900: invalid SQL statement
    SVRMGR> exit
    Server Manager complete.
    /home1/oracle $ sqlplus /

    SQL*Plus: Release - Production on Thu May 23 12:05:05 2002

    (c) Copyright 1999 Oracle Corporation. All rights reserved.

    Connected to:
    Oracle8i Enterprise Edition Release - Production
    With the Partitioning option
    JServer Release - Production

    SQL> prompt ---------
    > /
    -------- /

    Hope that helps,

    Senior Oracle DBA

    Oracle DBA forums at:

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Click Here to Expand Forum to Full Width

We have made updates to our Privacy Policy to reflect the implementation of the General Data Protection Regulation.