Home » RDBMS Server » Server Administration » how to extract db data to flat file
how to extract db data to flat file [message #289006] Wed, 19 December 2007 04:50 Go to next message
mrkcse
Messages: 62
Registered: November 2007
Location: Mumbai,India
Member
HI,

Iam in a need to extract data from database server which is using oracle 10g and load into a flat file from specified date to till date.

and again i want these flat file data is inserted into other database.

help me


Re: how to extract db data to flat file [message #289007 is a reply to message #289006] Wed, 19 December 2007 04:53 Go to previous messageGo to next message
varu123
Messages: 754
Registered: October 2007
Senior Member
Use UTL_FILE and sqlloader.
Re: how to extract db data to flat file [message #289048 is a reply to message #289006] Wed, 19 December 2007 06:07 Go to previous messageGo to next message
Michel Cadot
Messages: 64151
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Or SQL*Plus and external table.

Regards
Michel
Re: how to extract db data to flat file [message #289067 is a reply to message #289006] Wed, 19 December 2007 07:35 Go to previous messageGo to next message
Littlefoot
Messages: 20901
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
I suppose Export and Import utilities (or Data Pump) aren't suitable (as you've mentioned a flat file. Does it have to be a flat file?); are they?
Re: how to extract db data to flat file [message #289070 is a reply to message #289067] Wed, 19 December 2007 07:39 Go to previous messageGo to next message
Michel Cadot
Messages: 64151
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Maybe a db link and remote copy can do the trick?

Regards
Michel
Re: how to extract db data to flat file [message #289363 is a reply to message #289070] Thu, 20 December 2007 23:39 Go to previous messageGo to next message
asherisfine
Messages: 63
Registered: June 2006
Location: India
Member
You can also use Heterogeneous connectivity feature provided by oracle to connect to any non oracle database and transfer your data Razz .
Re: how to extract db data to flat file [message #289465 is a reply to message #289006] Sat, 22 December 2007 00:18 Go to previous message
mrkcse
Messages: 62
Registered: November 2007
Location: Mumbai,India
Member
thanks all for the information.
Previous Topic: Dropping undo tablespace after ORA-00376, 01110
Next Topic: View Oracle User Objects (table, synonyms etc)
Goto Forum:
  


Current Time: Fri Dec 09 17:05:29 CST 2016

Total time taken to generate the page: 0.08506 seconds