title: Transfer data from an ORACLE View to greenplum DB table
body: <p>I have an Oracle view containing very large amount of data in it and I want to migrate this data in a table in Greenplum database. Is there any way I can write any query in Postgresql to fetch that Oracle view's data?</p>
  
  <p>If not possible by query in Postgresql, kindly suggest me some way to access Oracle view from Linux server, so that I can create data file from that Oracle view to my Linux server and load that file via gpfdist to a Greenplum table.</p>
  
  <p>NOTE: an Oracle view is from third party, I only have an access to view that data (I have all the connection info) I can access that view via SQL Developer
  NOTE: Exporting data from SQL Developer to my local machine is not feasible here as the data is very large</p>
  
  <p>Thanks,
  Sunny</p>