OraFAQ Forum: Server Administration » how to extract db data to flat file

Home » RDBMS Server » Server Administration » how to extract db data to flat file

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

how to extract db data to flat file [message #289006]

Wed, 19 December 2007 04:50

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

Report message to a moderator

Re: how to extract db data to flat file [message #289007 is a reply to message #289006]

Wed, 19 December 2007 04:53

varu123
Messages: 754
Registered: October 2007

Senior Member

Use UTL_FILE and sqlloader.

Report message to a moderator

Re: how to extract db data to flat file [message #289048 is a reply to message #289006]

Wed, 19 December 2007 06:07

Michel Cadot
Messages: 68737
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Or SQL*Plus and external table.

Regards
Michel

Report message to a moderator

Re: how to extract db data to flat file [message #289067 is a reply to message #289006]

Wed, 19 December 2007 07:35

Littlefoot
Messages: 21823
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?

Report message to a moderator

Re: how to extract db data to flat file [message #289070 is a reply to message #289067]

Wed, 19 December 2007 07:39

Michel Cadot
Messages: 68737
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Maybe a db link and remote copy can do the trick?

Regards
Michel

Report message to a moderator

Re: how to extract db data to flat file [message #289363 is a reply to message #289070]

Thu, 20 December 2007 23:39

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

Report message to a moderator

Re: how to extract db data to flat file [message #289465 is a reply to message #289006]

Sat, 22 December 2007 00:18

mrkcse
Messages: 62
Registered: November 2007
Location: Mumbai,India

Member

thanks all for the information.

Report message to a moderator

Previous Topic:	Dropping undo tablespace after ORA-00376, 01110
Next Topic:	View Oracle User Objects (table, synonyms etc)

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Feb 28 06:08:21 CST 2025