Toad World® Forums

Schema export error 12.11.03

While generatng schema script I get following error :

SELECT DECODE(o.TYPE#, 2, ‘TABLE’, 4, ‘VIEW’, 6, ‘SEQUENCE’, 7, ‘PROCEDURE’,
8, ‘FUNCTION’, 9, ‘PACKAGE’, 13, ‘TYPE’, 22, ‘LIBRARY’,
23, ‘DIRECTORY’, 24, ‘QUEUE’, 28, ‘JAVA SOURCE’, 29, ‘JAVA CLASS’,
66, ‘JOB’, 67, ‘PROGRAM’, 74, ‘SCHEDULE’,
32, ‘INDEXTYPE’, 33, ‘OPERATOR’,42, ‘MATERIALIZED VIEW’, 90, ‘CREDENTIAL’) object_type,
pp.*
FROM SYS."_CURRENT_EDITION_OBJ" o, sys.user$ u,
(Select p.grantee, p.owner, p.table_name, null column_name, p.privilege, p.grantable, p.hierarchy, ‘NO’ as common
from sys.dba_tab_privs p
where p.grantee IN (Select GRANTED_ROLE FROM SYS.DBA_ROLE_PRIVS WHERE GRANTEE = :own)
and not ((length(p.table_name) = 30) and
(substr(p.table_name, 1, 4) = ‘BIN$’) and
(substr(p.table_name, 27, 4) = ‘==$0’))
order by pp.owner, pp.table_name, pp.privilege

[Error] Execution (12: 1): ORA-00933: SQL command not properly ended

I see that and will fix, thanks. Looks like it only happens for 11gR2 and older.

By the way, uncheck “User’s roles” at the top of the “object types” tab to avoid the error. Or use 12.10. The error only happens in beta.