Because the ora-cle sql interface bypassed this case

direct=y

flashback_scn=41515551378

Export done in US7ASCII character set and AL16UTF16 NCHAR character set

About to export specified tables via Direct Path ...

The best way to speed up exports is to use the following parameter:

direct=y

larger buffer reduces the number of OCI execute calls required to fetch the same num-ber of rows. The default buffer size is 64K.

It’s not unusual to see a 30 to 50 percent reduction in export time through the use of direct path export compared to a conventional path export of the same data. The RECORDLENGTH parameter can be used to tune the performance of direct path export. The maximum value is 64K. Experiments indicate that changing the setting doesn’t make a very significant difference to export performance, maybe giving an extra 5 to 10 percent reduction in elapsed time.

problems in this case, avoiding direct�y for export should fix the problem.

Security Considerations for
Direct Path

POLICY privilege (either through a role or directly) are exempt from VPD and

Oracle label security enforcement in both direct and conventional path exports.