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