To export the user specified...
. The process is pre - schema derived objects and operations
. HRM is export users external function library name
. The PUBLIC type derived synonyms
. Synonyms are export special type
Being exported object types of user NANYANG_TYSL
The export NANYANG_TYSL object...
Being exported database link
EXP - 00106: the database link password invalid
EXP - 00000: export end failure


Must be after all the dblink delete to backup, but also need to start creating dblink after delete, good trouble ah, have a great god can solve the problem.

CodePudding user response:

Does anyone know

CodePudding user response:

Dblink cannot use exp export, can only use expdp export,
But when you use the impdp after import, because the source and the target of library tnsnames. Ora configuration is different, still need to manually create the target library dblink,

CodePudding user response:

Object library also don't know the password, you must use the sysdba from sys. Link to withdraw $,

CodePudding user response:

Exp and can export dblink, of course, but the original poster this case, was lazy, in fact, only import the reconstruction after the

Using the export import this way, only allow you to rebuild dblink was luckily ~