UTL_FILE_DIR INIT.ORA PARAMETER EXECUTION
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: UTL_FILE_DIR INIT.ORA PARAMETER EXECUTION

  1. #1
    Join Date
    Feb 2001
    Posts
    286
    Hi all!

    I have a query:

    1.Is it safe to rely on Export and Import Backups for recovery in case something goes wrong or should I go for Hot and cold one.We are in the development stage.

    2.What are the steps to attach a File to UTL_FILE_DIR so that after executing the package UTL_FILE_DIR should read the attached file and store the output to another file.Is this possible.

    Please forward your comments!

    Regards,

    Amitst.

  2. #2
    Join Date
    Sep 2001
    Location
    Dallas, TX
    Posts
    27

    Export/Import

    Well,

    you can do with export/import as approach to have realiable backup and recover data. You would still need a skeletal DB to do the import (FYI).

    Once the paramter (utl_file_dir) is set, utl_file package can be used to read and write to that directory only.

    Hope this helps.

    BK.

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