Generating scripts for materialized views missing schema prefix. (4304524)

If a user has a Materialized View, and has private synonyms of it on other schema, when they run Create Script for the materialized view the script is missing the schema name, but has the dot. For example, on the create script below, the second line it says " .EMPLOYEES_PRIV_SYN" when it should be "DANNY.EMPLOYEES_PRIV_SYN" this also happens in the Script Tab in the schema browser even when include schema name/include schema owner is checked.


***Create Script Results****

DROP PUBLIC SYNONYM EMPLOYEES_MV_SYN;

DROP SYNONYM .EMPLOYEES_PRIV_SYN;


DROP MATERIALIZED VIEW MATHEW.EMPLOYEES_MV;

CREATE MATERIALIZED VIEW MATHEW.EMPLOYEES_MV
TABLESPACE SYSTEM
NOCACHE
LOGGING
NOPARALLEL
BUILD IMMEDIATE
NEVER REFRESH
AS
SELECT * FROM EMPLOYEES;

CREATE PUBLIC SYNONYM EMPLOYEES_MV_SYN FOR EMPLOYEES_MV;



CREATE SYNONYM EMPLOYEES_PRIV_SYN FOR EMPLOYEES_MV;

STATUS:

Issue resolved in Toad for Oracle 9.0.1. Please download the newest version of Toad from http://support.quest.com.