All tables Export failed through EXPDP utility

[mahesh_phegade1]

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

[former_member188883]

Hi,

Any improper use of exclude or include can give you any of the below mentioned errors

ORA-39001: invalid argument value

ORA-39071: Value for INCLUDE is badly formed.

So check your parfile.exp for such non-exceptable formats.

Hope this helps.

Regards,

Deepak Kori

[mahesh_phegade1]

Hi,

Following Note help me to overcome export erros:-

Note 976435 - Support for Oracle Data Pump in BRSPACE

Note 778426 - Special exports and imports with BRSPACE

Regards,

Mahesh