Suggetion For Export And Import
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4

Thread: Suggetion For Export And Import

  1. #1
    Join Date
    Nov 2001
    Location
    Delhi
    Posts
    31
    Dear Friend!
    I want to clear my doubt.I have a particular user for which I am transfering data from some non oracle existing dtabase and testing it.and taking export backup if it is sucessful and if not I am droping all tables and then importing data from my old backup.In droping tables it is taking too much time(2000 tables, I could not want drop user).Then I am importing table.
    I want to know is tere any way to import data (previos dump) without droping tables.
    Please suggest me.
    Thanks
    Imti
    Junior DBA

  2. #2
    Join Date
    May 2001
    Location
    Maryland, USA
    Posts
    409
    Yes you can import data into existing tables. Set IGNORE=Y in imp command.

    Also try using SQL loader if you want to transfer data from non-oracle database.
    -- Dilip

  3. #3
    Join Date
    Sep 2001
    Location
    NJ, USA
    Posts
    1,287
    Originally posted by patel_dil
    Yes you can import data into existing tables. Set IGNORE=Y in imp command.
    If table has any rows and PK / UK CONSTRAINS
    IGNORE=Y will work more slower than IGNORE=N
    because oracle have to check each importing row aginst PK/UK constraint.
    then if in import file we have any constraint violation oracle
    have to log this row to imprt protocol (extrimly slow operation).

    In my mind this isn't good recomendation.

    may be truncate all tables before import can help, but i
    didn't test that method newer.


  4. #4
    Join Date
    May 2001
    Location
    Maryland, USA
    Posts
    409
    yea have to agree ...process is slower with the existing data with constraints. And like shestakov suggested, maybe you can try importing the data after truncating the tables involved. But again it all depends on how critical the existing data is. Hope all this steps are done in test environment first.
    -- Dilip

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