export error with LOBs

[daust]

While exporting I had errors only with “LOB” and “JOB” object_type (We have on that schema almost 100 jobs, non of them where exported), schema2ddl export that out.

And few LOB-s
export: TRANSLATIONS_LOB[LOB] => 20:03:17 (Exporter,ERROR) sql error: ORA-31600: invalid input value LOB for parameter OBJECT_TYPE in function GET_DDL (LOB was not exported with schema2ddl)
ORA-06512: at "SYS.DBMS_METADATA", line 6681
ORA-06512: at "SYS.DBMS_METADATA", line 6466
ORA-06512: at "SYS.DBMS_SYS_ERROR", line 105
ORA-06512: at "SYS.DBMS_METADATA_INT", line 4166
ORA-06512: at "SYS.DBMS_METADATA_INT", line 4643
ORA-06512: at "SYS.DBMS_METADATA_INT", line 9656
ORA-06512: at "SYS.DBMS_METADATA", line 6409
ORA-06512: at "SYS.DBMS_METADATA", line 6522
ORA-06512: at "SYS.DBMS_METADATA", line 9672
ORA-06512: at line 1

[daust]

The "LOB" object type is a generated type. It is at least generated for table. Thus I will exclude all generated objects by default and add that to the query. This cannot be turned off, but you can see it in the generated query. Anyhow, later we will have a custom query and could work around potential issues here.

[daust]

Also, nested tables will be excluded by default as a subquery which cannot be turned off.