Direct Path or Conventional Path
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 8 of 8

Thread: Direct Path or Conventional Path

Hybrid View

  1. #1
    Join Date
    Oct 2001
    Posts
    127
    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

  2. #2
    Join Date
    Jan 2001
    Location
    Vancouver, Canada
    Posts
    87

    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

  3. #3
    Join Date
    Oct 2001
    Posts
    127
    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.

  4. #4
    Join Date
    Feb 2000
    Location
    Singapore
    Posts
    1,758
    The data imported will be same whether you use direct path or conventional path.
    Sanjay

  5. #5
    Join Date
    Aug 2001
    Location
    chennai,bangalore
    Posts
    840
    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

  6. #6
    Join Date
    Feb 2001
    Posts
    389
    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.

  7. #7
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,447
    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

  8. #8
    Join Date
    Feb 2001
    Posts
    290
    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
  •  


Click Here to Expand Forum to Full Width