Problem with Import Table Data in 11.5

Brian R Trull <[email protected]>
Newsgroups gmane.comp.db.oracle.toad.free
Message-ID <OFC70A31C1.EB1B0646-ON852579F0.00589218-852579F0.0058C573@mck.us.ray.com>


I believe I've found a bug with Import Table Data in the new version 11.5.
This is the scenario: Loading a tab-delimited text file into a table with
four columns.  For the majority of rows, the fourth column is null. In my
original input file, a value doesn't appear in the fourth position until
row 107. When I get to the file preview, the fourth column isn't displayed
at all and I have no way to add it.

Failing that, I edited the input file and moved one of the rows with data
in the fourth position to the beginning of the file, thinking that would
goose the import into loading the fourth column. Now when I get to the file
preview, the fourth column is indeed listed, but the value that is in the
first row is propagated to all the rows instead of being null.

I've attached two screen shots. 11_0 shows the data as it should look. This
is from version 11.0, where it works fine. The 11_5 file is the way it
loads in 11.5.

Excel input works fine, so I have this as a workaround.

(See attached file: 11_0.png)(See attached file: 11_5.png)
11_0.png (image/png, 2.9 KB) - not displayed
11_5.png (image/png, 3.1 KB) - not displayed
lmpx.com only provides a reader for public news (NNTP) servers. It is not affiliated with the servers or forums shown here and is not responsible for the content of articles, which is written by their respective authors.