Situation - I have a data file I want to load, but it has additional data that doesn't fit my table and if possible I don't want to have to change the table structure.

So I look at the docs for LOAD TABLE and there we are - just what I need:

When a column list is specified, it lists the columns that are expected to exist in the file and the order in which they are to appear. Column names cannot be repeated. Column names that do not appear in the list will be set to null/zero/empty or DEFAULT (depending on column nullability, data type, and the DEFAULT setting). Columns that exist in the input file that are to be ignored by LOAD TABLE can be specified using the column name "filler()".

However, what ever I do, I don't seem to be able to have more that one column ignored. If I use filler() more than once I get a duplicate column error.

Is there away of getting columns ignored without hitting the Column names cannot be repeated restriction ?



asked 14 Dec '10, 17:27

Justin%20Willey's gravatar image

Justin Willey
accept rate: 21%

Well, I'm quite sure that I have often used LOAD TABLE with several filler() columns in V10/v11 without any problem. So I guess the problem might have a different cause...

(14 Dec '10, 20:17) Volker Barth

Please provide some sample code and version info

(15 Dec '10, 07:31) Thomas Dueme...

Just to confirm my first comment: Yes, with V10.0.1 and V11.0.1, we definetely have regularly used import procedures with several "filler()" arguments in one single LOAD TABLE statement.

(15 Dec '10, 08:36) Volker Barth

I agree... I tried using filler() multiple times and it worked just fine in 10.0.1. I would need to see sample code in order to determine what problem you are running into.

(20 Dec '10, 16:31) John Smirnios
Comment Text Removed

Hi - thanks everybody for the feedback - how people describe is it is certainly how I expected it to work. I've worked around the problem for now (not hard just adding dummy columns) but I'll put together a demonstration of my problem that doesn't involve customer data and post it during the holidays.

(24 Dec '10, 09:32) Justin Willey
Be the first one to answer this question!
toggle preview

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here



Answers and Comments

Markdown Basics

  • *italic* or _italic_
  • **bold** or __bold__
  • link:[text]( "title")
  • image?![alt text](/path/img.jpg "title")
  • numbered list: 1. Foo 2. Bar
  • to add a line break simply add two spaces to where you would like the new line to be.
  • basic HTML tags are also supported

Question tags:


question asked: 14 Dec '10, 17:27

question was seen: 634 times

last updated: 14 Dec '10, 17:27