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

Thread: Imp error: ORACLE error 1400 encountered

Threaded View

  1. 05-13-2010, 10:18 AM #9
    mahajanakhil198
    mahajanakhil198 is offline Senior Member
    Join Date
    Oct 2008
    Location
    Chandigarh, India
    Posts
    322
    Quote Originally Posted by vnktummala View Post
    Akhil - look into constraints=n and indexes=n imp options.

    how many tables you are trying to import? if you don't want to use constraints=n indexes=n then provide individual table names to imp excluding the one you have already imported.

    Thanks,

    Around 98 tables are there.

    Is there a way to import constraints only later on If I use constraints=no?

    I was thinking of some other workaround. Firstly import only MAM_ASSETS table with no constraints and indexes. Then, use import with ignore=n. When table MAM_ASSETS is reached, it will be skipped with error and its indexes and constraints should get imported. I wonder if it would work.
    Last edited by mahajanakhil198; 05-13-2010 at 10:30 AM.
    lucky
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

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

Forum Rules

Click Here to Expand Forum to Full Width