Everyone a great god, and want to excuse me now have a server installed 99.16.55.12 respectively, and 55.16 two databases, now don't put the data import of 12 to 16, it will be the method of data export and import in the same network segment can be connected directly to 16 data into the database operation

CodePudding user response:

Yes, study the building Lord impdp + network_link way, very suitable for your needs now,

CodePudding user response:

reference 1st floor wmxcn2000 response:

yes, I study the impdp + network_link way, very suitable for your needs, now

can teach how to do

CodePudding user response:

About such an operating


On the target machine
1. Create a public database link, such as named XXXX, attention to the problem of permissions here
2. The command line:
Impdp system/oracle network_link=XXXX remap_schema=source_user: target_user remap_tablespace=source_tbs: target_tbs

CodePudding user response:

Create the create public database link kk1 connect to user identified by password using '(database) to import data
And then create a directory d1, log in, (on the database to import)
Impdp "/as sysdba" network_link=kk1 directory=d1 logfile=MMM. Log schemas=what do you want to import, remap_schema=before import schema: after import the schema remap_tablespce=before import table Spaces: after import table space
Exclude=statistics

Build dblink under test, select sysdate from dual @ kk1

CodePudding user response:

Use dbLink can't?