My Oracle Support Banner

Execution of streams2ogg.sql fails with PL/SQL: ORA-00942: table or view does not exist (Doc ID 2678986.1)

Last updated on SEPTEMBER 29, 2020

Applies to:

Oracle Database - Enterprise Edition - Version 11.2.0.4 and later
Information in this document applies to any platform.

Symptoms

Execution of the streams2ogg.sql script from the following note:

Oracle Streams to GoldenGate Migration Utility (Doc ID 1912338.1)

fails with an ORA-942:

-- <GG_USER> and <DIR> are substitutes for actual values

SQL> @streams2ogg.sql

Package created.

No errors.


Enter value for gg_username: <GG_USER>
old3253:     GGusername := '&gg_username';
new3253:     GGusername := '<GG_USER>';


Enter value for staging_dir: <DIR>
old3262:       execute immediate 'CREATE OR REPLACE DIRECTORY test_dir1 AS ''&staging_dir''';
new3262:       execute immediate 'CREATE OR REPLACE DIRECTORY test_dir1 AS ''<DIR>''';

Warning: Package Body created with compilation errors.

Errors for PACKAGE BODY STREAMS2OGG:

LINE/COL ERROR
-------- -----------------------------------------------------------------
716/5    PL/SQL: SQL Statement ignored
716/52   PL/SQL: ORA-00942: table or view does not exist
719/5    PL/SQL: SQL Statement ignored
719/55   PL/SQL: ORA-00942: table or view does not exist

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.