| Index problem after import using imp [message #361686] |
Thu, 27 November 2008 08:15  |
balamuruganm
Messages: 2
Registered: November 2008
|
Junior Member |
|
|
I created a database in Oracle Database 10g Express Edition Release 10.2.0.1.0 in one machine. I created users, tables, views etc through script. I inserted data.
Now I wanted the data to be moved to another machine. I installed Oracle Database 10g Express Edition Release 10.2.0.1.0 there. I took a dmp from the first machine using the exp command. The copied the dump to the new machine and imported it using the imp command. Everything went fine.
I accessed the database using my web application in the new machine. For most part it was fine. But for some queries it is taking a long time to execute. (more than 10 minutes)
After using explain plan and trace I found out that the query running in machine 1 picks up different index than when the query is running in machine 2.
Why is there a discrepancy? Is that problem with Oracle Database 10g Express Edition Release 10.2.0.1.0?
Please help.
Thanks
|
|
|
|
| Re: Index problem after import using imp [message #361697 is a reply to message #361686] |
Thu, 27 November 2008 10:31  |
 |
Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille
|
Senior Member
Account Moderator |
|
|
Prove it. Post it. Describe it.
Just explaining what you did helps us very little.
Check the statistics (atleast the last_analyzed from user_tables/user_indexes).
Recollect the stats and try again.
Depending on how exactly you did export/import, the stats may get copied /changed.
[Updated on: Thu, 27 November 2008 10:33] Report message to a moderator |
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
