OraFAQ Forum: Server Utilities

Home » RDBMS Server » Server Utilities » Import

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

Import [message #69206]

Wed, 21 November 2001 04:50

NewDBA
Messages: 3
Registered: November 2001

Junior Member

Can u import into a database over database link.

Thanx

NewDBA

----------------------------------------------------------------------

Report message to a moderator

Re: Import [message #69207 is a reply to message #69206]

Wed, 21 November 2001 07:20

Suresh Vemulapalli
Messages: 624
Registered: August 2000

Senior Member

database link is used to connect between 2 databases. you use import utility to import database objects/data into database from exported file.There is no need of using database link to import.

----------------------------------------------------------------------

Report message to a moderator

Re: Import [message #69209 is a reply to message #69207]

Wed, 21 November 2001 08:18

NewDBA
Messages: 3
Registered: November 2001

Junior Member

I was trying to use the process power from one machine to do the import, across the network
into a slower machine.
So my question still is, is it possible to import across a database link

----------------------------------------------------------------------

Report message to a moderator

Re: Import [message #69217 is a reply to message #69207]

Fri, 23 November 2001 08:26

Suresh Vemulapalli
Messages: 624
Registered: August 2000

Senior Member

you dont need to use database link to do that.
create entry in tnsnames.ora file and try to import using that connect string. basically you want to try import from remote machine to db server.Database link is mainly to access one DB to other. that is useful in pl/sql programs or remote db queries run in other DB's.

HTH
SURESH

----------------------------------------------------------------------

Report message to a moderator

Re: Import [message #69239 is a reply to message #69207]

Wed, 28 November 2001 01:48

NewDBA
Messages: 3
Registered: November 2001

Junior Member

Thank You.

----------------------------------------------------------------------

Report message to a moderator

Previous Topic:	Re: FREE OCP PAPERS
Next Topic:	Re: OCP Exam Papers

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed Apr 24 22:41:16 CDT 2024