3 Replies Latest reply: Nov 15, 2012 1:34 AM by saurabh RSS

    Getting Error While trying to export Data in Table Mode

    vk82
      Hi Guru's,

      My DB Version: 10.2.0.1.0
      My OS Version: Windows Server 2003

      During exporting Table data i am getting below error:
      Connected to: Oracle Database 10g Enterprise Edition Release 10.1.0.2.0 - Production
      With the Partitioning, OLAP and Data Mining options
      ORA-31626: job does not exist
      ORA-31637: cannot create job SYS_EXPORT_TABLE_01 for user SYS
      ORA-06512: at "SYS.DBMS_SYS_ERROR", line 95
      ORA-06512: at "SYS.KUPV$FT_INT", line 601
      ORA-39080: failed to create queues "" and "" for Data Pump job
      ORA-06512: at "SYS.DBMS_SYS_ERROR", line 95
      ORA-06512: at "SYS.KUPC$QUE_INT", line 1550
      ORA-01403: no data found


      command which i used for export is ;
      expdp username/password@db_name tables=(schema.table_name:partition_name) directory=test_dir dumpfile=file_name.dmp logfile=logfile_name.log content=all



      Can you please help me what happen to export
      when i use original export import i am able to do that but not with expdp why is it so