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

Thread: import command

  1. #1
    Join Date
    Mar 2001
    Location
    south africa
    Posts
    401

    import command

    Hi

    can some one tell what is the import command to import data with out

    dropping the exisitng tables, if i am importing same from another DB



    Thank you

  2. #2
    Join Date
    Feb 2000
    Location
    Singapore
    Posts
    1,758
    imp ignore=y
    Sanjay G.
    Oracle Certified Professional 8i, 9i.

    "The degree of normality in a database is inversely proportional to that of its DBA"

  3. #3
    Join Date
    Jan 2001
    Posts
    2,828
    Hi

    In the import options just specify IGNORE=Y..that will ignore the table creation errors and import will continue to import the data..type imp help=y and you will see other options too

    regards
    Hrishy

  4. #4
    Join Date
    Mar 2001
    Location
    south africa
    Posts
    401

    thank you

    thank you both ..it worked

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