Results 1 to 4 of 4
  1. #1
    Join Date
    Dec 2003
    Posts
    76

    Unanswered: SQL Loader (Multiple Files)

    Hi,

    I'm in the midle of an database migration, and therefore I have several tables to load into Oracle.
    Currently, I am thinking of doing it by using several CTL files (one for each table imported) but I would like to know if any of you recommends any other option (like for instance, one CTL file with all the instructions for all tables)

    Thanks!

  2. #2
    Join Date
    Jan 2004
    Location
    Croatia, Europe
    Posts
    4,094
    Provided Answers: 4
    A migration? What is a source, what is a target? If both are Oracle databases, why wouldn't you rather use export/import utilities or even a database link?

  3. #3
    Join Date
    Dec 2003
    Posts
    76
    No, no .... I forgot to mention it.

    It's a migration from Informix to Oracle.
    I don't want to use Oracle Migration Workbench, and therefore Ia have multiple files to load. Each file relating to a single table data.

    Thanks!

  4. #4
    Join Date
    Jan 2004
    Location
    Croatia, Europe
    Posts
    4,094
    Provided Answers: 4
    Well, I'd rather keep it simple: one control file per data file.

Tags for this Thread

Posting Permissions

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