Results 1 to 4 of 4
  1. #1
    Join Date
    Jul 2003
    Posts
    23

    Unanswered: Import Of Data from 8i to9i

    Hi

    I am Facing an Error In importing a file exported from Oracle 8.1.7 to be imported Into Oracle 9.2.0.1

    It says that the Table Exists can we have a solution only to import Table data not the structure


    thanks
    Meraj
    System Support Engineer &Developer

  2. #2
    Join Date
    Mar 2002
    Location
    Reading, UK
    Posts
    1,137
    add ignore=Y to your imp command line so it ignores errors. You may get a primary key violation if your table isnt empty though.

    Alan

  3. #3
    Join Date
    Jul 2003
    Posts
    23
    Originally posted by AlanP
    add ignore=Y to your imp command line so it ignores errors. You may get a primary key violation if your table isnt empty though.

    Alan
    I Have added But Its trying to alter table and gives error
    System Support Engineer &Developer

  4. #4
    Join Date
    Mar 2002
    Location
    Reading, UK
    Posts
    1,137
    Whats the error and what is the alter table trying to do?

    Alan

Posting Permissions

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