My Oracle Support Banner

[ADW, ATP]: Creating "ADB_ADVISOR" Package Fails With Error "PL/SQL: ORA-00942: table or view does not exist" (Doc ID 2555797.1)

Last updated on OCTOBER 08, 2019

Applies to:

Autonomous Data Warehouse - Version N/A and later
Information in this document applies to any platform.

Symptoms

The ADB Schema Advisor utility provided in the following note analyzes on-premise or cloud Oracle Database schemas for the suitability of migration to the Oracle Autonomous Database:
<> - Oracle Autonomous Database Schema Advisor

Executing the script creates adb_advisor package. Creating the adb_advisor package as per the note fails with following error:

==================
SQL> show errors
Errors for PACKAGE BODY "ADB_ADVISOR":

LINE/COL ERROR
-------- -----------------------------------------------------------------
384/19 PL/SQL: SQL Statement ignored
427/37 PL/SQL: ORA-00942: table or view does not exist
437/9 PL/SQL: Statement ignored
437/34 PLS-00364: loop index variable 'T_ROW' use is invalid
457/13 PL/SQL: Statement ignored
457/16 PLS-00364: loop index variable 'T_ROW' use is invalid
488/13 PL/SQL: Statement ignored
==================

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.