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

Thread: IMP problems

  1. #1
    Join Date
    Oct 2002
    Posts
    284

    IMP problems

    Hi all

    Sun 5.8 and 9.2

    I did a EXPORT using System account with FULL=Y option. Now i just need to overwrite all objects owned by user RSMITH. His id already exists in both the Databases.

    So i did an IMPORT like this :

    IMP system/password@abcdb1 buffer=10000 file=c:\scc.dmp fromuser=rsmith touser=rsmith

    But it doesn't update the tables with new data and doesn't create new Tables if Source has new tables...

    Where am i going wrong ?

    I need to overwite existing records if exists or add new records if not exists or create new tables if not exists.

    How do i do it in EXPORT ?

    thanks

  2. #2
    Join Date
    Nov 2000
    Location
    Pittsburgh, PA
    Posts
    4,166

    Re: IMP problems

    Originally posted by vr76413
    But it doesn't update the tables with new data and doesn't create new Tables if Source has new tables...
    This can be done with an ignore=y

    I need to overwite existing records if exists
    To my knowledge Imp won't do this.

  3. #3
    Join Date
    Jan 2001
    Posts
    3,134
    Ignore=Y will create any structures that are not present, it will NOT
    affect ("update") the data.

    Why not just truncate all of the tables that the user owns and then run your import, this is easy to do with dynamic SQL. Or if the user is identical drop it and do a schema level import, that is another option but may be overkill for this particular application.

    MH
    I remember when this place was cool.

  4. #4
    Join Date
    Jan 2001
    Posts
    3,134
    One other thing when imorting...

    I usually use BUFFER= in conjunction with COMMIT=Y
    The commit is good to use especially when you have larger tables since Oracle will by default, commit after the entire table is imported. If the table is large you can blow out your rollback.
    I usually set my buffer at 4000000, this way a commit is issued at roughly every 3MB's.

    Just a suggestion.

    MH
    I remember when this place was cool.

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