Wednesday, December 01, 2010

Oracle Export Tables with CLOB

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.