Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

oracle IMP using tnsname.ora for different IP address for each database

user12251389Jun 9 2016 — edited Jun 9 2016

I am using the following oralce IMP command for import which works fine if i am running it on same server.

imp TMR/TMR@PO11254 PARFILE=imp_tmc_no_constraints.par

imp TM/TM@PO11254 PARFILE=imp_tm_no_constraints.par

imp TMR/TMR@PO11254 PARFILE=imp_tmc_constraints.par

imp TM/TM@PO11254 PARFILE=imp_tm_constraints.par

But now i have database clustering for which i have 4 IPs for each database, that means it seems i have to use the tsnname.ora for the connection. But i didn't know how to use it in my below command and how it works.

This post has been answered by top.gun on Jun 9 2016

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on Jul 7 2016

Added on Jun 9 2016

#database-key-features, #export-import-sql-loader-external-tables

1 comment

870 views