How to imp data from Oracle 10g to 11g and how to verify before decommission 10g?
Posted on 2014-09-22
I have Oracle 10g server running on w2003 and used it since 2005. Now we purchased new 11g running on windows 2008. I do daily backup using exp and imp command. My plan is to export all but import selected schema only (full export but not full import). At the moment, we have around 35 schemas and we only want to import 20 schemas only.
I can do it by running imp command in new server and choose enter selected schemas. But how do I know it actually imported 100% ? What are the things that I need to do before doing import? How does oracle imp work? Does it create users/schema/password, tablespaces same as old server? Does it really importing all objects such as index, view, materialized views, database links, function, procedures etc…?
I want to understand how import works. Consider the following scenario (old 10g server).
UserA was created. Then we create database link to other remote database (RemoteA) to access few tables.
Later we created synonym and views for all RemoteA tables. No physical table was created under UserA.
After that we created another user, UserB. There are some tables, views etc created under this user.
This user also needs to connect with RemoteA. Aprt from that, UserB also granted access to its table (UserB_table)
With this scenario, (correct me if wrong) We have to create and import UserA first, then UserB so that UserB can
grant UserB_table to UserA. Does imp process know the right sequence when I imported selected user/schema
UserA, UserB, UserC etc… ?
For your info, I am not a dba but there is noone else than me (limited resources). I am a developer using database driven tools such as phpbuilder and my knowledge on this (oracle backup/restore) is very limited but willing to learn more with your guidance. So please help me.
Thanks in advance.