Database Utilities (MOSC)

MOSC Banner

ORA-19510 error during expdp: failed to set size of 4294967295 blocks for file

edited Feb 7, 2017 11:45AM in Database Utilities (MOSC) 2 commentsAnswered ✓

expdp fails on one of our unit server. It works on other servers fine, for example production server.

when I use exp instead, it works on unit.

/home/oracle> expdp ... schemas=..  include=TABLE:\"IN \(\'...\'\)\" directory=LOADER_DIR dumpfile=TEST1.dmp logfile=TEST1.log

Export: Release 11.2.0.4.0 - Production on Mon Feb 6 11:04:04 2017

Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved.

Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production

With the Partitioning, Automatic Storage Management, OLAP, Data Mining

and Real Application Testing options

Starting "DMT"."SYS_EXPORT_SCHEMA_01": ...  include=TABLE:"IN ('COUNTY')" directory=LOADER_DIR dumpfile=TEST1.dmp logfile=TEST1.log

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center