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

Thread: import..

  1. #1
    Join Date
    Nov 2002
    Posts
    115

    import..

    hi

    I have full export dump file taken in 8i on win 2k. Now i import
    into my test database with the following command


    > imp system/.... file=c:\expdat.dmp log=c:\imp.log ignore=y full=y
    rows=y

    my import log file shows number of row rejected errors due to duplication , Oracle erros like 2494 and 990 etc.

    how can i ignore those errors ?


    an immediate reply is appreciated
    Prasad

  2. #2
    Join Date
    Jul 2002
    Location
    Lincolnshire, IL
    Posts
    203
    Drop the user schema, create it again in the same Tablespace and import...at all if you can afford to drop the user...
    "Greatest Rewards come only with Greatest Commitments!"

  3. #3
    Join Date
    Jul 2002
    Location
    Lincolnshire, IL
    Posts
    203
    I mean is there all the user schemas already available in the test DB or... is there any data already available in Test Database..??
    "Greatest Rewards come only with Greatest Commitments!"

  4. #4
    Join Date
    Nov 2002
    Posts
    115
    sandy,

    I don't want to drop the schemas, it will remain in test database
    and some data also existed in those schemas.

    But,the errors like object already existed,unique key violation ,row rejected errors should n't be existed in import log file.
    Prasad

  5. #5
    Join Date
    Jan 2001
    Posts
    3,134
    Did you truncate the existing tables?
    Do you have duplicate values in the other database?

    MH
    I remember when this place was cool.

  6. #6
    Join Date
    Jul 2003
    Posts
    4
    Download OraSchemer at http://www.qwerks.com/download/6578/OraSchemer.exe to help you

  7. #7
    Join Date
    Oct 2000
    Location
    Saskatoon, SK, Canada
    Posts
    3,925
    IS the instance you are importing is fresh? If it already has data, they why not try INCTYPE=restore

    -Sam
    Thanx
    Sam



    Life is a journey, not a destination!


  8. #8
    Join Date
    Nov 2002
    Posts
    115
    hi

    how can we import full exported dump file into existed scemas ?

    kindly give the command line parameters..


    Thanx in adv
    Prasad

  9. #9
    Join Date
    Nov 2002
    Posts
    115
    hi
    My test db contains schemas,tables and data of last week. Now I
    wish to import data from last week to today with the help of full
    export dump file which i have taken from main db.

    How can I achieve it ....?
    Prasad

  10. #10
    Join Date
    Jun 2003
    Location
    Singapore
    Posts
    11
    Hi
    You may consider exporting the schema with CONSTRAINTS=N and GRANTS=N parameters. Before importing you may also consider disabling the constraints which may need to be enabled again by cleaning up the data.
    When importing have tried IGNORE=Y parameter which will not give error if the object is already created?

    Bhaskara
    OCP 9i

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