SQL Loader problem
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: SQL Loader problem

  1. #1
    Join Date
    Sep 2001
    Location
    NEW YORK
    Posts
    17

    Question

    I'm using SQL Loader for the first time. THe problem i have is that when i attempt to migrate data from an access database to an oracle database it only works for one of the 7 tables. The particular table that works has no references to any of the others, its just a users table for password/userid.

    Any of the other tables that all have pk and fk references between them always give the message that the columns in them are not found in the "users" table. But those columns arent needed in the users table nor are there any references to the users table in my other tables.


    So if someone has an idea what might be wrong, please let me know!

    THANKS!!

    [Edited by netrix on 10-13-2001 at 08:09 PM]

  2. #2
    Join Date
    Aug 2001
    Location
    Waterloo, On
    Posts
    547
    I think the problem is that the 'dependent' keys are being loaded before the primary keys.
    I suggest dropping the pkeys and fkeys before loading and recreating them after load.
    Alternatively, you can try to load table with pk before table(s) with fks.
    All the best.

    Raminder Singh

    Oracle Certified DBA: Oracle 8i, 9i


    Mail me at raminderahluwalia@rediffmail.com.

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