mahsnj , PMFJI, but the "Oracle9i Database Utilities" manual, in chapter 1 - Export, says :
"Rows in tables that contain objects and LOBs will now be exported using conventional path, even if direct path was specified."
SO, I pass a BUFFER param always, so IF my direct-path ends being "downgraded" to an conventional path due the LOBs it uses the correct BUFFER, and if not BUFFER is ignored (at least this have been my experience).
04-18-2006, 03:40 PM
why do you need to make an export? Have you tried to copy the data via db link?
04-20-2006, 07:34 PM
04-21-2006, 05:31 AM
ummm you should be providing an update with what you have done
04-25-2006, 10:20 PM
Finally Option-2 works fine for me.
Exp system@INTORA1 TABLES= (COL.ABC_TEXT) FILE=C:\ABC_TEXT.dmp BUFFER=37748736
Thanks all for there help.