File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
http://aspose.com/file-tools
The moose likes Oracle/OAS and the fly likes How can i imp to remote oracle database Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of EJB 3 in Action this week in the EJB and other Java EE Technologies forum!
JavaRanch » Java Forums » Products » Oracle/OAS
Bookmark "How can i imp to remote oracle database" Watch "How can i imp to remote oracle database" New topic
Author

How can i imp to remote oracle database

David Rocks
Ranch Hand

Joined: Apr 24, 2001
Posts: 162
Hi,
I am trying to import to a remote oracle database. I have a dmp file from my own database but i am sure that you can imp to a remote db by something like.
imp user/password@ipaddress:1521:instance
it does not work though i am sure i am close in my syntax. can anybody tell me what i am doing wrong?
Mark Spritzler
ranger
Sheriff

Joined: Feb 05, 2001
Posts: 17249
    
    6

Well if you have access to the remote database, you can have it in your tnsnames.ora file and then you connect exactly like you do to your local database.
For example
<<TNS_NAME HERE>> =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = <<ip address here>> (PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = <<database service name here>>
)
)
then you use:
imp user/password@<<TNS_NAME HERE>>
Mark


Perfect World Programming, LLC - Two Laptop Bag - Tube Organizer
How to Ask Questions the Smart Way FAQ
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: How can i imp to remote oracle database
 
Similar Threads
Accessing external DataSource
"oracle 9i Client" and "Oracle 9i personal edition"
oracle 9i client for 8i database
Re: Connecting to an orcle data base. EJB with BMP.
how to use policy tool for Applets in java ?