| Quick import question [message #54691] |
Wed, 27 November 2002 17:16  |
Tony
Messages: 190
Registered: June 2001
|
Senior Member |
|
|
I recently imported a oracle 7.3.4 database into 8.0.6. Everything went through fine. But I imported the Entire database. Is that an issue? Because won't the 8.0.6 SYSTEM objects be overwritten by the 7.3.4 objects? Should I import only the relevant users?
Thanks
|
|
|
|
| Re: Quick import question [message #54692 is a reply to message #54691] |
Wed, 27 November 2002 20:15  |
andrew again
Messages: 2577
Registered: March 2000
|
Senior Member |
|
|
Look at the creation time of the objects after the import and see if anything stands out. I'm not sure whether the new objects retain their original timestamps (I think so) else they will have the date when imported.
select object_name, object_type, created, last_ddl_time
from dba_objects
order by...;
Also - if you look at the contents of the .dmp file (in Unix use "strings expdat.dmp > ddl.sql" or "exp ... show=y").
You should see that all packages, procedure, synonyms etc are "create..." rather than "create or replace..." so existing objects don't get overwritten.
I'm sure metalink will have a conclusive answer for you though.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
