During the switch of a job to convert non-partition table to a partitioned table. Error such as the following is shown:
[2] 02/25 20:44:46 AbortScript: Aborted ORA-06550: line 1, column 69:
PLS-00103: Encountered the symbol "END" when expecting one of the following:
( - + case mod new not null others <an identifier>
<a double-quoted delimited-identifier> <a bind variable> avg
count current exists max min prior sql stddev sum variance
execute forall merge time timestamp interval date
<a string literal with character set specification>
<a number> <a single-quoted SQL string> pipe
<an alternatively-quoted string literal with character set specification>
<an alternatively
(os errno 25) (other error -6550)
[2] 02/25 20:44:46 Can't update QUEST_SCRIPT status: ORA-12899
[2] 02/25 20:44:46 ORA-12899: value too large for column (actual: , maximum: ).
Line feed / incorrect formatting is found in the statement EXECUTE QUEST_EXEC.CREATE_TLOCK('CBA', 'QUEST_SPC_TMP_413462_LRTAB','BEFORE INSERT OR UPDATE OR DELETE');
1. Clean up the abort job
2. Modify the script to remove line feed or regenerate the script to see whether the format of the script is now correct.
3. Run the partition job
© 2025 Quest Software Inc. ALL RIGHTS RESERVED. Terms of Use Privacy Cookie Preference Center