DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3
  1. #1
    Join Date
    Sep 2002
    Hi Experts,

    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.

  2. #2
    Join Date
    Jul 2002
    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.

  3. #3
    Join Date
    Aug 2002
    Bangalore, India
    Can you post your export and import parfiles??? and the details regarding no. of schemas???

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Click Here to Expand Forum to Full Width

We have made updates to our Privacy Policy to reflect the implementation of the General Data Protection Regulation.