Direct Path or Conventional Path

[amits]

What is the difference between Direct Path and Conventional Path Export apart from performance point of view or Direct path may not be able to export the LOB objects.
If there are no LOB objects in the database ,whether it is same to export from Direct Patch or Conventional Path.
Thanks

[mzahid]

Conventional path -
Oracle will employ SQL inserts on our behalf to load data

Direct Path -
Oracle do not use SQL. Formats database blocks directly.

[amits]

What i want to know is whether the data imported by the export dum created by Direct Path Method and Conventional Path will make any difference or it will be same.
Thanks.

[SANJAY_G]

The data imported will be same whether you use direct path or conventional path.
Sanjay

[anandkl]

yes there will be differnce when u import a export dump done using convention or direct path.If you import the export dump done using direct method,then the import will be done faster as it will bypass the block formating process done while using conventional and will directly write into the oracle blocks.

regards
anandkl

[gpsingh]

export shall not make a difference (LOBS are not exported in direct path),
but while importing you have to keep lots of things in mind,

direct mode,storage space ,index usablity , performance of full table scans after import etc.

[pando]

Originally posted by anandkl
yes there will be differnce when u import a export dump done using convention or direct path.If you import the export dump done using direct method,then the import will be done faster as it will bypass the block formating process done while using conventional and will directly write into the oracle blocks.

regards
anandkl

incorrect, there is not such statement
direct path only wokrs for export

[mrvajrala]

I Vote to PANDO,,,

Direct Path is only for SQL*Loader and Export...

Thanks,
Madhu