Toad World® Forums

materialized view - create script ora-00904


#1

in .1, creating a script for a materialized view throws a ora-00904. Spooled SQL below.

Select c.MVIEW_NAME TABLE_NAME, NULL COLUMN_NAME, c.COMMENTS

FROM SYS.DBA_MVIEW_COMMENTS c

WHERE c.OWNER = :own

AND c.COMMENTS IS NOT NULL

and C.MVIEW_NAME = :OneObjectName

order by c.table_name

Error: ORA-00904: “C”.“TABLE_NAME”: invalid identifier


#2

Thanks for the spool sql. It will be fixed next beta.

From: michael.c.nisse_546 [mailto:bounce-michaelcnisse_546@toadworld.com]

Sent: Wednesday, July 10, 2013 4:52 PM

To: toadoraclebeta@toadworld.com

Subject: [Toad for Oracle - Beta Discussion Forum] materialized view - create script ora-00904

materialized view - create script
ora-00904

Thread created by michael.c.nisse_546

in .1, creating a script for a materialized view throws a ora-00904. Spooled SQL below.

Select c.MVIEW_NAME TABLE_NAME, NULL COLUMN_NAME, c.COMMENTS

FROM SYS.DBA_MVIEW_COMMENTS c

WHERE c.OWNER = :own

AND c.COMMENTS IS NOT NULL

and C.MVIEW_NAME = :OneObjectName

order by c.table_name

Error: ORA-00904: “C”.“TABLE_NAME”: invalid identifier

To reply, please reply-all to this email.

Stop receiving emails on this subject.

Or
Unsubscribe from Toad for Oracle - Beta
notifications altogether.

Toad for Oracle - Beta Discussion Forum

Flag
this post as spam/abuse.