3 Replies Latest reply on Feb 24, 2010 10:04 AM by Marwim

    Exporting a view to a flat file

      Hi all,

      Running Oracle 9i on Windows.

      We have a stored procedure which runs a number of packages and populates a view called v$logmnr_contents.
      We woudl like to export the contents of the view to a flat file so that it can be transferred over to another

      What options do we have for this? I've been reading about an Oracle package called utl_file, is this the
      only option? I'm looking for whichever method is the most straightforward to implement.

      Thanks in advance.


      Edited by: user482248 on Feb 23, 2010 12:03 PM