0 Replies Latest reply: Apr 4, 2014 5:39 AM by 915395 RSS

    Error running TSAMUpgradeOracle.sql

    915395

      After installing Patchlev 019 to TSAM 12.1.1.0 I run the script TSAMUpgradeOracle.sql and had the following error:

       

      SQL> connect TSAM/TSAM@orcl

      Connected.

      SQL> @ TSAMUpgradeOracle.sql

       

       

      Type created.

       

       

       

       

      Function created.

       

       

       

       

      Function created.

       

       

        ALTER TABLE MON_CPSEGMENT DROP CONSTRAINT FKMON_CPSEGM222330;

        *

      ERROR at line 100:

      ORA-06550: line 100, column 3:

      PLS-00103: Encountered the symbol "ALTER" when expecting one of the following:

      ( begin case declare end exception exit for goto if loop mod

      null pragma raise return select update while with

      <an identifier> <a double-quoted delimited-identifier>

      <a bind variable> << continue close current delete fetch lock

      insert open rollback savepoint set sql execute commit forall

      merge pipe purge

       

       

       

       

      SP2-0158: unknown SHOW option "WARNINGS"

      No errors.

      SQL>                                   

       

      Can anyone help please ?