Skip to Content
0
Nov 26, 2011 at 05:41 AM

All tables Export failed through EXPDP utility

172 Views

Hello Friends,

We are exporting Tablepsace which contains total 20658 table.We

are putting complete range of table to export say 1-20658,after which

export ended with errors as:-

ORA-39001: invalid argument value

ORA-39071: Value for TABLES is badly formed

But when we given range as 1-100 & 101-300 and its working fine without

any problems.

Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bit Production

With the Partitioning, Data Mining and Real Application Testing options

BR0278E Command output of '/usr/sap/R72/SYS/exe/run/brtools -f printcmd -U /oracle/R72/sapbackup/.user.pas | /oracle/R72/102_64/bin/expdp parfile=/oracle/R72/sapreorg/sehhnyvb/parfile.exp':

ORA-39001: invalid argument value

ORA-39071: Value for TABLES is badly formed.

BR0280I BRSPACE time stamp: 2011-11-26 04.11.45

BR0279E Return code from '/usr/sap/R72/SYS/exe/run/brtools -f printcmd -U /oracle/R72/sapbackup/.user.pas | /oracle/R72/102_64/bin/expdp parfile=/oracle/R72/sapreorg/sehhnyvb/parfile.exp': 1

BR1161E Table export failed

BR0280I BRSPACE time stamp: 2011-11-26 04.11.45

BR1160I 0 tables exported by EXPDP utility

BR0280I BRSPACE time stamp: 2011-11-26 04.11.45

BR0669I Cannot continue due to previous warnings or errors - you can go back to repeat the last action

BR0671I Enter 'b[ack]' to go back, 's[top]' to abort:

Can you please help us out?

Regards,

Mahesh Phegade