Method 1:
Exp system@OraSID TABLES= (owner.table_name) DIRECT=Y RECODELENTH=65335 FILE=C:\table_name.dmp
Method 2:
Exp system@OraSID TABLES= (owner.table_name) FILE=C:\table_name.dmp BUFFER=37748736
The Buffer parameter applies only to conventional path export. It has no effect on a direct path Export. For direct path exports use RECORDLENGTH parameter to specify the size of the buffer that Export uses for writing to the export file. 64K is the max buffer size.
No comments:
Post a Comment