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

Last updated on APRIL 17, 2023

Applies to:

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

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