Error generating diagram from Oracle Schema in pdf format

[javc1974]

Congratulations for your job!!!

Feb 12, 2016 10:46:41 AM sf.util.DatabaseUtility executeSql WARNING: Error executing SQL, SELECT /+ PARALLEL(AUTO) / NULL AS TABLE_CATALOG, TABLES.OWNER AS TABLE_SCHEMA, TABLES.TABLE_NAME, DBMS_METADATA.GET_DDL('TABLE', TABLES.TABLE_NAME, TABLES.OWNER) AS TABLE_DEFINITION FROM ALL_TABLES TABLES INNER JOIN ALL_USERS USERS ON TABLES.OWNER = USERS.USERNAME WHERE USERS.USERNAME NOT IN ('ANONYMOUS', 'APEX_PUBLIC_USER', 'BI', 'CTXSYS', 'DBSNMP', 'DIP', 'EXFSYS', 'FLOWS_30000', 'FLOWS_FILES', 'HR', 'IX', 'LBACSYS', 'MDDATA', 'MDSYS', 'MGMT_VIEW', 'OE', 'OLAPSYS', 'ORACLE_OCM', 'ORDPLUGINS', 'ORDSYS', 'OUTLN', 'OWBSYS', 'PM', 'SCOTT', 'SH', 'SI_INFORMTN_SCHEMA', 'SPATIAL_CSW_ADMIN_USR', 'SPATIAL_WFS_ADMIN_USR', 'SYS', 'SYSMAN', 'SYSTEM', 'TSMSYS', 'WKPROXY', 'WKSYS', 'WK_TEST', 'WMSYS', 'XDB', 'XS$NULL')
AND NOT REGEXPLIKE(USERS.USERNAME, '^APEX[0-9]{6}$') AND NOT REGEXPLIKE(USERS.USERNAME, '^FLOWS[0-9]{5}$') AND TABLES.TABLE_NAME NOT LIKE 'BIN$%' ORDER BY TABLE_SCHEMA, TABLE_NAME;

java.sql.SQLException: ORA-31603: object "TOAD_PLAN_TABLE" of type TABLE not found in schema "CUA_DATA_PRO" ORA-06512: at "SYS.DBMS_METADATA", line 5088 ORA-06512: at "SYS.DBMS_METADATA", line 7589 ORA-06512: at line 1

This error is because TOAD_PLAN_TABLE is a global temporary table of user/schema CUA_DATA_PRO.

It would be useful a flag for excluding Oracle temporary tables that when you use it in this query add the clause "AND TEMPORARY!='Y'"

Thank you very much

[schemacrawler]

I cannot reproduce the problem. What version of Oracle are you using? What version of the Oracle JDBC driver are you using?

[javc1974]

I am using Oracle RDBMS 11.2.0.3 and Oracle JDBC Driver 11.2.0.4 Thanks

Date: Fri, 12 Feb 2016 19:54:32 -0800 From: notifications@github.com To: SchemaCrawler@noreply.github.com CC: chuberep@hotmail.com Subject: Re: [SchemaCrawler] Error generating diagram from Oracle Schema in pdf format (#32)

I cannot reproduce the problem. What version of Oracle are you using? What version of the Oracle JDBC driver are you using?

— Reply to this email directly or view it on GitHub.

[adriens]

Can you provide the command line ?

[schemacrawler]

Also, please try using the latest version of the Oracle JDBC driver, 12.1.0.2. There are bugs in the earlier versions of the driver.

[adriens]

Any news @javc1974 ? Did you make it work ?

[schemacrawler]

@javc1974 - I will close this issue if I do not hear back from you.

[schemacrawler]

No response.