-
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
-
difference between Direct Path and Conventional Path Export
Conventional path -
Oracle will employ SQL inserts on our behalf to load data
Direct Path -
Oracle do not use SQL. Formats database blocks directly.
Mohammad Zahid
Software Developer
Database Management Applications.
Vancouver, Canada
E-mail: mzahid@shaw.ca
-
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.
-
The data imported will be same whether you use direct path or conventional path.
Sanjay
-
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
anandkl
-
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.
-
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
-
I Vote to PANDO,,,
Direct Path is only for SQL*Loader and Export...
Thanks,
Madhu
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|