SQL Performance (MOSC)

MOSC Banner

Ora 1403 while running xplore script in SQLT

edited Jan 3, 2019 7:10PM in SQL Performance (MOSC) 10 commentsAnswered

hi,

I am running in to ora 1403 no data found while running last script Xplore method.

Log file shows as below

SQL>

SQL>EXEC xplore.snapshot_plan('xplore_{001}_[^^run_id.]_(00000)', 'XECUTE', 'N');

BEGIN xplore.snapshot_plan('xplore_{001}_[0001]_(00000)', 'XECUTE', 'N'); END;

*

ERROR at line 1:

ORA-01403: no data found

ORA-06512: at "TC26651.XPLORE", line 744

ORA-06512: at line 1

It errors out while running EXEC xplore.snapshot_plan.. Has somebody run in to this before?

Thanks and regards,

Siddharth

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center