OraFAQ Forum: Server Utilities » extract data from one database to other - both database cant talk each other (behind firewall)

Home » RDBMS Server » Server Utilities » extract data from one database to other - both database cant talk each other (behind firewall)

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

extract data from one database to other - both database cant talk each other (behind firewall) [message #296095]

Thu, 24 January 2008 10:25

dbaexp
Messages: 4
Registered: January 2008
Location: us

Junior Member

Please anyone can guide.
i have several databases (9i and 10g), often need to transfer data from one to other. all are behind firewall. They cant talk to each other. What is best and easy way to automate this task? also some database have blob and clob data. Some data need to mask (encrypt too).
Thanks in advance!!

Report message to a moderator

Re: extract data from one database to other - both database cant talk each other (behind firewall) [message #296098 is a reply to message #296095]

Thu, 24 January 2008 10:29

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

Senior Member
Account Moderator

If they are behind firewall, there is no way to automate the process otherwise there is a hole in your firewalls.

Regards
Michel

Report message to a moderator

Re: extract data from one database to other - both database cant talk each other (behind firewall) [message #296099 is a reply to message #296098]

Thu, 24 January 2008 10:34

dbaexp
Messages: 4
Registered: January 2008
Location: us

Junior Member

Automate in the sense using some procedure - passing information to procedure and procedure will create file from table- than ftp that file to other database and load into table.
(can do ftp from one databse to other)

[Updated on: Thu, 24 January 2008 10:36]

Report message to a moderator

Re: extract data from one database to other - both database cant talk each other (behind firewall) [message #296101 is a reply to message #296099]

Thu, 24 January 2008 10:37

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

Senior Member
Account Moderator

export, transfert file, connect, transfer file, connect transfer file... for any number of firewalls you have to cross and finally import.

Regards
Michel

Report message to a moderator

Re: extract data from one database to other - both database cant talk each other (behind firewall) [message #296104 is a reply to message #296101]

Thu, 24 January 2008 10:48

dbaexp
Messages: 4
Registered: January 2008
Location: us

Junior Member

can we do imp/exp for blob and clob data? also can we specify query (selection criteria)to exp? can we encrypt some column with exp?

Report message to a moderator

Re: extract data from one database to other - both database cant talk each other (behind firewall) [message #296105 is a reply to message #296104]

Thu, 24 January 2008 10:51

dbaexp
Messages: 4
Registered: January 2008
Location: us

Junior Member

Also could you tell me difference between imp/exp and utl_file/sqlldr? both way we can copy data from one table to other? what are pros/cons for each other?

Report message to a moderator

Re: extract data from one database to other - both database cant talk each other (behind firewall) [message #296106 is a reply to message #296105]

Thu, 24 January 2008 10:53

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

Senior Member
Account Moderator

Database Utilities

Regards
Michel

Report message to a moderator

Previous Topic:	Export by date
Next Topic:	ORA-01461: can bind a LONG value only for insert into a LONG column

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sun Jan 12 02:51:00 CST 2025