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

    Exporting views on a schedule - Newbie Question


      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 on a remote PC for the time being.  The Database itself is 10g.


      Any pointers or help would be really appreciated.