Return
-
Title
Column Alias missing in Materialized View DDL -
Description
Column alias is missing from the DDL for Materialized Views (MV) when the MV has column aliases defined.
Steps to replicate1. I built a materialized view using a column aliasCREATE MATERIALIZED VIEW testmv (testcol)
NOCACHE
LOGGING
NOCOMPRESS
NOPARALLEL
BUILD IMMEDIATE
NEVER REFRESH
AS
select * from dual
/
2. desc testmv
Name Null? Type
----------------------------------------- -------- ----------------------------
TESTCOL VARCHAR2(1)
Â3. Go to Schema Browser | Materialized Views | ScriptsDROP MATERIALIZED VIEW TESTMV
/
--
-- TESTMV (Materialized View)
--
CREATE MATERIALIZED VIEW TESTMV
LOGGING
BUILD IMMEDIATE
NEVER REFRESH
AS
/* Formatted on 7/7/2010 2:17:47 AM (QP5 v5.149.1003.31008) */
SELECT * FROM DUAL
/COMMENT ON MATERIALIZED VIEW TESTMV IS 'snapshot table for snapshot TESTMV'
/
à -
Resolution
WOARKAROUND:
None
STATUS:
Waiting for fix in a future release of Toad for Oracle. -
Defect ID
ST75784