3 Replies Latest reply: Feb 24, 2010 4:04 AM by Marwim RSS

    Exporting a view to a flat file

    485251
      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
      server.

      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.

      Dave

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