Return
-
Title
Getting error when trying to add a new database in spotlight. -
Description
The Spotlight User Wizard has encountered an error. An error was reported for table "SoOBody"
The error is:
success with compilation error
PLS-01918: 9.2 and earlier wrap formats are not permitted in table SooBody
ORA-04063: package body "SPOT.QUEST_SOO_SCHEMA_MGR" has errorsORA-06508: PL/SQL: could not find program unit being called: "SPOT.QUEST_SOO_SCHEMA_MGR" -
Resolution
Currently, you will have to set "permit_92_wrap_format" to true when creating a new Spotlight user, it can be set it back after the user created.
-
Defect ID
SOO-2690 -
Additional Information
Submitted reference SOO-2690 enhancement request