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.