Results 1 to 4 of 4
  1. #1
    Join Date
    Feb 2006
    Posts
    173
    Provided Answers: 1

    Question Unanswered: Which record is utl_file reading?

    System info: Oracle 10gR2 / Unix on Solaris & Oracle 8.1.7 / Unix on Solaris

    Sometimes we have very large import files we process, let's say I have a comma delimited flat file with 2,134,567 records and I want to know which record that utl_file( in stored procedure ) is currenty on( or just read is fine ).

    How can I determine which record# that utl_file is currently reading without having to modify any code?


    Is there some OS command I can use or is there one of the Oracle Sytem tables/views in the SYS schema I can query?


    tia

  2. #2
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    >How can I determine which record# that utl_file is currently reading without having to modify any code?
    IMO, you can't.
    You can lead some folks to knowledge, but you can not make them think.
    The average person thinks he's above average!
    For most folks, they don't know, what they don't know.
    Good judgement comes from experience. Experience comes from bad judgement.

  3. #3
    Join Date
    Dec 2003
    Location
    Oklahoma, USA
    Posts
    354
    Have to agree... however, since you importing to a table, why don't you write something that monitors how many records are now in the import target table?
    JoeB
    save disk space, use smaller fonts

  4. #4
    Join Date
    Feb 2007
    Location
    Bratislava, Slovakia
    Posts
    85
    several comments:
    1, regards for developer, how can make procedure without monitoring system?
    2, why use this procedure utl_file on oracle 10g?? external tables are faster
    3, you can use some logging procedure or built-in package dbms_application_info
    http://www.oracle-base.com/articles/...ATION_INFO.php

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •