Yesterday i did my restore by export/import .
before importing i dropped allmytables,constraints,views,procedures,
synonyms ,sequences ,in my QA machine and imported from my
Production Database . After importing i found that 40 tables and 80 constraints are missing in my QA Database.may i know any specific reason why it is happening like this .please reply me.
Thanks in Advance.
What does ur log file say? If it says no errors, then have a look at the exported file contents with show=y option and check if it has the tables which u find missing after import. Either the tables did not export or u had errors while importing.
Can you post your export and import parfiles??? and the details regarding no. of schemas???
Click Here to Expand Forum to Full Width