who is "U" and how come they would be setting anything for you?
http://docs.oracle.com/cd/B19306_01/server.102/b14215/exp_imp.htm#sthref2313 http://docs.oracle.com/cd/B19306_01/server.102/b14215/exp_imp.htm#CEGIIHCE documentation states:
... . If OBJECT_CONSISTENT is set to y,
each object is exported in its own read-only transaction, even if it is partitioned. In contrast, i
f you use the CONSISTENT parameter, then there is only one read-only transaction.
...
so, object_consistent is like this:
loop over all objects
set transaction read only - begin transaction
export current object in it's entirety (partitioned table - all partitions)
commit - end transaction
end loop
consistent is like this:
set transaction read only - begin transaction
loop over all objects
export current object
end loop
commit - end transaction
consistent = y would give you a dmp file as of a single point in time.
object_consistent = y would give you a dmp flie consisting of individual objects, each as of their own individual points in time.