Local server: oracle database can be connected to a remote server, can be in Linux operating backstage,
Tools can be used at a remote server: connect the oracle database, no background interactive command interface, no background,


How the DMP file in local impdp command for the imported into the server, and can only connect to the database server

That is, the DMP file on the local server, need in the local server performs impdp statement import the data to the remote server

CodePudding user response:

Not, unless the local storage mounted to the server, such as using NFS

CodePudding user response:

how to perform locally impdp command the DMP file into the server

No,

There are several ways to avoid it,
1,'ll copy files to the server,
2, leading to the local, to exp,
3, leading to a local, create dblink on a remote machine, using network_link parameters,

CodePudding user response:

Can be executed on the server directly impdp, i.e., the source side not exported DMP file, using impdp + dblink to data import directly to server database,

CodePudding user response:

reference oracle_awen reply: 3/f

can execute impdp directly on the server, which is the source side not exported DMP file, using impdp + dblink to data import directly to server database,

problem is that the remote server without background connection permissions

CodePudding user response:

reference oracle_awen reply: 3/f

can execute impdp directly on the server, which is the source side not exported DMP file, using impdp + dblink to data import directly to server database,

problem is that the remote server does not have background operation permission