4 Replies Latest reply: Mar 19, 2012 12:33 PM by RN RSS

    External table

    RN
      I created external table as db user. The file is location on the db server and the dba has created directory object and granted necessary privs for me.

      Question is
      Is it possible to have log file generated on my local file system instead of the file going to server's file system? Because with latter approach, I have to always ask dba to send me the log file. Reading the log file through utl_file won't be that intutive.

      Is there a standard way of parsing log file and dumping its contents to a db table?

      Thanks,
      RN
        • 1. Re: External table
          Srini Chavali-Oracle
          Pl post details of OS and database versions, along with what you mean by "local file system". The log file directory for the external table is determined in the definition of the external table - if this directory is a shared directory that he "local file system" has access to, your requirement can be met in theory. Security and other considerations may prevent such an implementation.

          http://docs.oracle.com/cd/E11882_01/server.112/e25494/tables013.htm

          HTH
          Srini
          • 2. Re: External table
            damorgan
            Only if you can map a directory object on the server that points to your local drive. And if your DBA allows you to do that I will be very surprised.

            Instead ... put the log file at the same location as the external table ... then create another external table that points to the log file. A simple SELECT * FROM will allow you to read the log file at will.
            • 3. Re: External table
              RN
              Thanks for your response.

              I got success in creating separate external table for the log file.


              Regards,
              • 4. Re: External table
                RN
                Thanks for your response, Srini.

                I got my answer from other user.