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

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
    Apr 2001
    Location
    Brisbane, Queensland, Australia
    Posts
    1,203
    Did you notice any errors in the import log.

    You can perform it again with SHOW=Y, maybe that'll help you track the issue down.

    Cheers,
    OCP 8i, 9i DBA
    Brisbane Australia

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