This content has been marked as final. Show 5 replies
please specify oracle version and error you are getting in import and what os you are using....
you can use network link from new server B to old server A. you have to exclude system users and indexes like below .
For example from 10g to 11g
impdp username/password FULL=Y
Edited by: dataseven on 23.Oca.2013 01:06
impdp EXCLUDE=INDEX TABLE_EXISTS_ACTION=replace directory=<name> logfile=<name> dumpfile=<name>
In this case the key is
TABLE_EXISTS_ACTION=replace means if Oracle finds table with the same name, it will replace with new loading table.
EXCLUDE=INDEX means you are excluding all the indexes while importing.
impdp user directory=directoryname logfile=logfilename dumpfile=dumpfilename EXCLUDE=INDEX TABLE_EXISTS_ACTION=REPLACE.
This should work for you.
I want to do DATA PUMP import (without indexes) to database instance name B from databaseTo exclude indexes, use the exclude like everyone has said.
instance name A.
Import should overwrite all existing objects.Data Pump can't overwrite all existing objects. All it can do is overwrite tables. If you have types, procedures, functions, etc in your dump file, they will not get overwritten. There is a lot of confusion in here about that.