Originally posted by julian
CONSISTENT=Y triggers Oracle to run SET TRANSACTION READ ONLY before exporting every single table or a partition of a table. That's all. Thus, for partitioned tables, even CONSISTENT=Y will not garantee that export is consistent.
I believe that it's "serializable",not "read only".