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.
Regards,
R.Rangarajan
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.
Reply With Quote
Bookmarks