skipping of a cloumn
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: skipping of a cloumn

  1. #1
    Join Date
    Nov 2000
    Posts
    1

    Exclamation

    hi, i have a control file that takes in duplicated column names. Is there anyway to skip one of them, as in when the sql loader sees that column name, skips it and continues to load the rest of the data but it will take in the data at the next occurance of that duplicated column.
    Thanks.

  2. #2
    Join Date
    Jun 2000
    Posts
    6
    As far as I know there is no way to skip columns from datafiles.

    A possible workaround is this:

    load the data as it is into a temporary table
    issue the create table as select col1, col2 col3.... from temp_table, omitting the column that you do not want.

    Try this and see if it works.
    Ora_dude

  3. #3
    Join Date
    Oct 2000
    Posts
    3
    to scip column from datafile with delimiters you can use FILLER type in control file. So instead of specifying data type like INTEGER or CHAR you can specify FILLER. But this will work only in Oracle8, not in Oracle7.

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