DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: After Import- Tables are missing

  1. #1
    Join Date
    Sep 2002
    Posts
    6
    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.
    Regards,
    R.Rangarajan

  2. #2
    Join Date
    Jul 2002
    Posts
    132
    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
    Location
    Bangalore, India
    Posts
    405
    Can you post your export and import parfiles??? and the details regarding no. of schemas???
    -nagarjuna

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