dbms_metadata.get_ddl

[Sousa04Participante]

não consegui realizar o export da base para user extrair o ddl
se houver mais uma carta na manga será bem vinda.

expdp userid=’/ as sysdba’ schemas=sousa04 dumpfile=sousa04.dmp directory=dmptemp VERSION=10.2.0.5

Export: Release 10.2.0.5.0 – 64bit Production on Quinta-Feira, 08 Setembro, 2011 10:40:37

Copyright (c) 2003, 2007, Oracle. All rights reserved.

Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.5.0 – 64bit Production
With the Partitioning, Data Mining and Real Application Testing options
Starting “SYS”.”SYS_EXPORT_SCHEMA_05″: userid=”/******** AS SYSDBA” schemas=sousa04 dumpfile=sousa04.dmp directory=dmptemp VERSION=10.2.0.5
Estimate in progress using BLOCKS method…
Processing object type SCHEMA_EXPORT/TABLE/TABLE_DATA
Total estimation using BLOCKS method: 128 KB
Processing object type SCHEMA_EXPORT/USER
Processing object type SCHEMA_EXPORT/SYSTEM_GRANT
Processing object type SCHEMA_EXPORT/ROLE_GRANT
Processing object type SCHEMA_EXPORT/DEFAULT_ROLE
Processing object type SCHEMA_EXPORT/PRE_SCHEMA/PROCACT_SCHEMA
Processing object type SCHEMA_EXPORT/TABLE/TABLE
Processing object type SCHEMA_EXPORT/TABLE/COMMENT
Processing object type SCHEMA_EXPORT/TABLE/STATISTICS/TABLE_STATISTICS
ORA-31693: Table data object “sousa04”.”SYS_EXPORT_SCHEMA_01″ failed to load/unload and is being skipped due to error:
ORA-02354: error in exporting/importing data
ORA-00604: error occurred at recursive SQL level 3
ORA-06502: PL/SQL: numeric or value error: character string buffer too small
ORA-06512: at “SYS.DBMS_METADATA”, line 3025
ORA-06512: at “SYS.DBMS_METADATA”, line 3191
ORA-06512: at “SYS.DBMS_METADATA”, line 4952
ORA-06512: at line 1
ORA-31694: master table “SYS”.”SYS_EXPORT_SCHEMA_05″ failed to load/unload
ORA-02354: error in exporting/importing data
ORA-00604: error occurred at recursive SQL level 3
ORA-06502: PL/SQL: numeric or value error: character string buffer too small
ORA-06512: at “SYS.DBMS_METADATA”, line 3025
ORA-06512: at “SYS.DBMS_METADATA”, line 3191
ORA-06512: at “SYS.DBMS_METADATA”, line 4952
ORA-06512: at line 1
Job “SYS”.”SYS_EXPORT_SCHEMA_05″ stopped due to fatal error at 10:41:05