Home » Developer & Programmer » Warehouse Builder » import flat files (oracle 10.1.1)
import flat files [message #376815] Thu, 18 December 2008 12:15 Go to next message
aarti81
Messages: 235
Registered: December 2007
Location: USA
Senior Member
Hi all
Can any one please tell me , how to import flat files from 'postgres database' on a completely different network?

Thank You
Re: import flat files [message #376823 is a reply to message #376815] Thu, 18 December 2008 13:05 Go to previous messageGo to next message
Littlefoot
Messages: 20896
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
If this "flat file" is anything close to a CSV file readable by SQL*Loader (including external tables feature), those could be ways to do the job.
Re: import flat files [message #376826 is a reply to message #376823] Thu, 18 December 2008 13:31 Go to previous messageGo to next message
aarti81
Messages: 235
Registered: December 2007
Location: USA
Senior Member
They are ASCI files and they are on a completely different network, so what should i use in sql loader to import the files?
Thanks
Littlefoot wrote on Thu, 18 December 2008 13:05
If this "flat file" is anything close to a CSV file readable by SQL*Loader (including external tables feature), those could be ways to do the job.

Re: import flat files [message #376827 is a reply to message #376826] Thu, 18 December 2008 13:50 Go to previous messageGo to next message
Littlefoot
Messages: 20896
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
I'd get those files over the network "closer to me", create a control file and load the data file into the database. If SQL*Loader suits your needs, here's the documentation.
Re: import flat files [message #376829 is a reply to message #376827] Thu, 18 December 2008 14:09 Go to previous message
aarti81
Messages: 235
Registered: December 2007
Location: USA
Senior Member
Thank You very much
Littlefoot wrote on Thu, 18 December 2008 13:50
I'd get those files over the network "closer to me", create a control file and load the data file into the database. If SQL*Loader suits your needs, here's the documentation.

Previous Topic: Always appears the same error description in ERR$$$_ERROR_REASON
Next Topic: Best Practice When a physical object (table/view) is modified
Goto Forum:
  


Current Time: Tue Dec 06 14:31:18 CST 2016

Total time taken to generate the page: 0.14120 seconds