7 Replies Latest reply on Jan 20, 2015 1:56 PM by thatJeffSmith-Oracle

    Exporting views on a schedule - Newbie Question

    2841897

      Hello Everyone.

       

      I'm sorry if this has been asked before, or is so basic I should be ridiculed!

       

      We're a mainly sql based company and have recently had a oracle database put in.  I have installed SQL Developer and have attached to the Database.

       

      What I need to do is either export the table or view data on a schedule.  Either in Excel format or directly into SQL.  I'll either use integration manager to then import the data into the given SQL Database.

       

      I've read a number of threads here but have been unsuccessful.  I've tried linking the server, but have been unsuccessful - I'm a complete newbie to Oracle!!!

       

      I'm using Version 4.0.3.16 on a remote PC for the time being.  The Database itself is 10g.

       

      Any pointers or help would be really appreciated.