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

Thread: Imp error: ORACLE error 1400 encountered

Threaded View

  1. #6
    Join Date
    Oct 2008
    Location
    Chandigarh, India
    Posts
    322
    Dave and PAVB, I understood.

    I separately created the table MAM_ASSETS and removed NOT NULL from problematic columns. Then I used ignore=y option to import. But somewhere while importing, it creates NOT NULL constraints on these columns and I again start receiving the same error.

    What can I do here? How could I remove the code from import that creates NOT NULL constraints?

    Or as a workaround, I am able import only MAM_ASSETS table. But now the problem is that I don't want to import MAM_ASSETS while importing the rest of schema. IMP doesn't provide something like exclude as in IMPDP.
    Last edited by mahajanakhil198; 05-13-2010 at 09:12 AM.
    lucky

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