OraFAQ Forum: Data Integration » import flat files

Home » Developer & Programmer » Data Integration » import flat files (oracle 10.1.1)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

import flat files [message #376815]

Thu, 18 December 2008 12:15

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

Report message to a moderator

Re: import flat files [message #376823 is a reply to message #376815]

Thu, 18 December 2008 13:05

Littlefoot
Messages: 21807
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.

Report message to a moderator

Re: import flat files [message #376826 is a reply to message #376823]

Thu, 18 December 2008 13:31

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.

Report message to a moderator

Re: import flat files [message #376827 is a reply to message #376826]

Thu, 18 December 2008 13:50

Littlefoot
Messages: 21807
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.

Report message to a moderator

Re: import flat files [message #376829 is a reply to message #376827]

Thu, 18 December 2008 14:09

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.

Report message to a moderator

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:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue Apr 16 05:02:45 CDT 2024