Export Problem

  • From: "Kumar, Arvind IN GGN SISL" <arvind.kumar2@xxxxxxxxxxx>
  • To: <oracle-l@xxxxxxxxxxxxx>
  • Date: Wed, 22 Nov 2006 15:12:48 +0530

Hi Friends,


   Env - windows 2003 Std Ed. Oracle Database 10g Enterprise Edition
Release .  Getting the following error  while exporting a


With the Partitioning, OLAP and Data Mining options

Export done in WE8MSWIN1252 character set and AL16UTF16 NCHAR character

server uses AL32UTF8 character set (possible charset conversion)

Note: indexes on tables will not be exported

. exporting pre-schema procedural objects and actions

. exporting foreign function library names for user CD3_CTL 

. exporting PUBLIC type synonyms

. exporting private type synonyms

. exporting object type definitions for user CD3_CTL 

About to export CD3_CTL's objects ...

. exporting database links

. exporting sequence numbers

. exporting cluster definitions

EXP-00056: ORACLE error 4021 encountered

ORA-04021: timeout occurred while waiting to lock object 

ORA-06512: at "SYS.DBMS_METADATA", line 1511

ORA-06512: at "SYS.DBMS_METADATA", line 1548

ORA-06512: at "SYS.DBMS_METADATA", line 1864

ORA-06512: at "SYS.DBMS_METADATA", line 3707

ORA-06512: at "SYS.DBMS_METADATA", line 3689

ORA-06512: at line 1

EXP-00000: Export terminated unsuccessfully



Tried to Describe at SQL Prompt 


SYS@dwp_new > 

SYS@dwp_new > desc dbms_metadata


ORA-03117: two-task save area overflow



SYS@dwp_new >



   Am i hitting any bug ????



Avind Kumar


Other related posts: