Home » Developer & Programmer » Designer » Export - Import
Export - Import [message #90801] Mon, 20 December 2004 05:10 Go to next message
Messages: 61
Registered: July 2004

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 Go to previous message
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"
Previous Topic: Setting up my own dedicated host
Next Topic: Designer2000 problem
Goto Forum:

Current Time: Sat May 18 00:49:53 CDT 2024