| Import: No package bodies [message #72344] |
Wed, 21 May 2003 05:00 |
gary
Messages: 35
Registered: January 2001
|
Member |
|
|
Having taken an export from one machine and imported it into another we have packages without bodies. These packages refer to another database down a database link. This link is also part of the dump file and points to a machine that the target box can't see, and therefore the packages are not able to compile.
Is there a more elegant solution then putting in a dummy entry into tnsnames [[for a SID]] to a database that can be seen [[with a different SID]]?
Is it possible to tell imp to import regardless of the fact an object is invalid? This would enable us to put in a link valid for the target environment and recompile.
Is it possible to import all objects except for the link?
Thanks in advance.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
