| Export - Import [message #90801] |
Mon, 20 December 2004 05:10  |
Daxesh
Messages: 61
Registered: July 2004
|
Member |
|
|
Hello,
I have just imported full database. After import is done I found so many invalid objects and I know its normal so ran one script to compile all invalid objects. Now my questions is I also found that some of the packages are not carried over even through I set to Y on Entire database while export. Also, I have installed TOAD and SPOTLIGHT on my exported database but when I imported those objects did not carry over. Can any body tell me why?
Thanks in advance.
|
|
|
|
| Re: Export - Import [message #90802 is a reply to message #90801] |
Mon, 20 December 2004 09:37  |
andrew again
Messages: 2577
Registered: March 2000
|
Senior Member |
|
|
If there is another object with the same name (e.g. a table), then the new object won't come across. Also, from the DDL syntax in the export file, you'll see that it is "create package..." rather than "create or replace package..." so the code in the dump file won't overwrite existing code.
$> strings abc.dmp | grep -i "create package"
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
