OraFAQ Forum: Server Administration » connection through http

Home » RDBMS Server » Server Administration » connection through http

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

connection through http [message #56704]

Fri, 18 April 2003 01:13

Iyad
Messages: 1
Registered: April 2003

Junior Member

Hi all,
I want to transfer my local database to a main database server. any one can help me to transfer my local database through an internet connection to the database server in a secure and efficient way..

Report message to a moderator

Re: connection through http [message #56709 is a reply to message #56704]

Fri, 18 April 2003 06:28

Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

i dont get u.
if you want to 'transfer' your database you can do any of the following
1. do an import/export
2. do an cold copy transport
3. do an RMAN Clone

Report message to a moderator

Re: connection through http [message #56715 is a reply to message #56704]

Fri, 18 April 2003 13:29

sai sreenivas jeedigunta
Messages: 370
Registered: November 2001

Senior Member

u can do as what Mr.Mahesh said..
u can export and import there..
if u r concern is to send that .DMP file through internet in a secured way..
u can use FTP(ofcourse for this u r remote machine should have a Static IP) ...else inform hackers not to come into u r way ;) (Kidding)...

sai

Report message to a moderator

Re: connection through http [message #57072 is a reply to message #56709]

Mon, 19 May 2003 09:16

d2k-programmer
Messages: 16
Registered: May 2003

Junior Member

Hello !
I'm in need of transfering data from one database to another.
To be more clear i have transfer transactions taken place at a branch database to a head office database
in which i'm keep all the branch datas.
Please explain me how can i do it ?
I'm familiar with export and import.But not with
cold copy
and
RMAN Clone

What are these ? How can i do it ?
Thanks
d2k programmer

Report message to a moderator

Re: connection through http [message #57074 is a reply to message #57072]

Mon, 19 May 2003 09:34

Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

export/import is much simple and best option.
Becuase u are looking into copying data from one database into another existing database.
here
data from db1 --->export/import ---> to db2 ( which already exist)
right?

cold copy and clone are methods in which, u create a new database somewhere else with the data from the old database.
data from db1 --->clone/cold copy ---> to another new database db3

Report message to a moderator

Re: connection through http [message #57089 is a reply to message #57074]

Tue, 20 May 2003 03:39

psmyth
Messages: 81
Registered: October 2002

Member

if your branch db can 'see' the head office db, you could setup a db_link from the branch db to the head office and send your new data across that.

Have a look into 'sql copy', a fairly under-used but quite useful command to copy between databases.

I wouldn't consider these options unless you have a secure encrypted connection between the branch and head office.

Report message to a moderator

Previous Topic:	Data transfering ???
Next Topic:	forms6i

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Sep 20 11:39:22 CDT 2024