Product: Aqua Data Studio

Version: 18.0.0-devi-202

Build #: 50789

Build Date: 2016-Aug-11 06:26:34 PM

 

Operating Environment: Windows 10 (10.0, amd64) / Cp1252 / en / US / Oracle Corporation 1.8.0_101-b13

Memory: Max=704,643,072;  Total=378,535,936;  Free=215,179,048;  CPUs=8

 

Steps:

1.In v18, connect with Oracle 12c DB and open QA window.

2.Execute following script in QA window:

CREATE TABLE "h_func_dep_matlog1"  (
   "EMP_ID"       NUMBER(1) NOT NULL,
   "EMP_FNAME"    VARCHAR2(50) NULL,
   "EMP_LNAME"    VARCHAR2(50) NULL,
   CONSTRAINT "h_func_dep_matlog12" PRIMARY KEY("EMP_ID")
   NOT DEFERRABLE
    VALIDATE
)
GO
CREATE MATERIALIZED VIEW LOG ON "h_func_dep_matlog1"
   PCTFREE 5
   TABLESPACE "SYSTEM"
   STORAGE (INITIAL 10K NEXT 10K)
GO
CREATE FUNCTION "h_func_dep_matlog2"(acc_no IN NUMBER)
   RETURN NUMBER
   IS acc_bal NUMBER(11,2);
   BEGIN
      SELECT "EMP_ID"
      INTO acc_bal
      FROM "MLOG$_h_func_dep_matlog1"
      WHERE "EMP_ID" = acc_no;
      RETURN(acc_bal);
    END;
 GO

3.Table,function and materialized view log will created.

4.Go to 'Materialized View Logs' object tree node and expand it.

5.Right click on 'MLOG$_h_func_dep_matlog1' materialized view log and select 'Script object to New Window As -> CREATE/DROP'

 

Result: 'CREATE MATERIALIZED VIEW LOG' script will not generated in QA.

 

Observation:

1. In View Log window, error message is displayed as "java.sql.SQLSyntaxErrorException: ORA-00942: table or view does not exist" but we have created 'h_func_dep_matlog1' table first and then used same table name for materialized view log.

2. In v17 build we didn't offer 'Script object to Window As' option on materialized view log.

 

Exception :