Question 2: questions about up sqlplus
Images of the service_name for NCDB I later I add 1
In PLSQL link the oracle database, and now the host is my local IP local have installed an oracle, and then the implementation of the uf researchers said from behind the service_name can link to the online computer server? Here I am not understand, why I didn't specify the IP address to the online server, he is how to connect to the server online? Said I will give this code online database covering,,,,
I perform this statement:
Impdp nc65/nc65 @ NCDB REMAP_SCHEMA=nc65: nc0510
Table_exists_action=replace directory=data_dir
Dumpfile=ncdb_20190526. DMP logfile=ncdb_20190526. Log
The question now is whether the impdp nc65/nc65 @ NCDB with our online database account password is the same,
REMAP_SCHEMA=nc65: nc0510 nc0510 here is my local,
Impdp [username]/[code] @ [service] user name is the local use up sqlplus login account and password, the service of what meaning be?
REMAP_SCHEMA=[source username 1], [2] target user name the source user name should be I export table users life? Is nc65 target user name 2 local user name is refers to me?
CodePudding user response:
In your tnsnames. Ora file NCDB is how to define? Which IP is the point? Is the server or your local IP?CodePudding user response:
Well, the connection on the way, does not need to configure tns_name mysql, usually directly:Mysql - uusername - ppassword - hip - pprot
But usually need to be in oracle tnsnames. Add tns_name ora, of course, you can directly connect:
Up sqlplus username/password @ IP: port/sid