A view is created in Schema browser where the last line of the query is commented. When viewing the script the ';' is also commented out. If you subsequently export the DDL for this along with other objects then the script fails with "Error: ORA-00933: SQL command not properly ended."
CREATE OR REPLACE FORCE VIEW SUSTEST.TESTVIEW
(COL2)
AS
SELECT COL2 FROM table3j
-- where rownum < 10; ** Note the semi-colon (;) is included as a comment
WORKAROUND
Check 'Export DDL' script option 'Always use '/' to end SQL statements' i.e.
CREATE OR REPLACE FORCE VIEW SUSTEST.TESTVIEW (COL2)
AS
SELECT COL2 FROM table3j
-- where rownum< 10
/
STATUS
Waiting for fix in a future release of Toad for Oracle
