Sql Loader reshuffles the records in a tex file.

Sql Loader reshuffles the records in a tex file.

Post by Tibor Karasz » Wed, 27 Nov 2002 20:34:09

Your question is similar to below:

"I throw a number of paper noted into a bag. I throw them sequentially. I then shake the bag.
When I now pick the notes out of the bag, I don't get the paper notes in the same sequence as
when I put them in the bag."

Rows in a table are not ordered. This is an important part of the relational model. Add another
column (IDENTITY perhaps) and have BULK INSERT generate a value for that column (assuming the
BULK INSERT has such an option, which I think it does).

Tibor Karaszi, SQL Server MVP
Archive at: http://groups.google.com/groups?oi=djq&as_ugroup=microsoft.public.sql...

> Hi,
> I have a text file with more than 1,00,000 rows. i want
> this text file to be loaded in the order of exists in the
> text file. But when i use the following code snippet, the
> bulk.txt file will be load into #Batch_101 table with some
> rows interchanged.

>  This is my bulk insert statement.

> i am not creating any cluster index for this table. This
> table have only one column COL1 with varchar(100) as
> datatype.

> Anyone help me please...


1. Using SQL*Loader to load a record sequential data file

Hi all,

I need to load a fixed-length record sequential datafile(i.e, no new-line
characters at end of record) using SQL*Loader into the Oracle database.

I am not able to find any way to do this in the SQL*Loader documentation.

I can change the file to Line sequential format(put a new-line character
at the end of every record), but the size of the data file makes this
approach prohibitive.

I would appreciate if anyone could help me out with this problem.



2. ORA-00942: Table or View does not exist????

3. SQL Loader: Flat file, multiple records per line

4. SQLXML Connection string DSN

5. Export To Tex file

6. pgsql-server/ ontrib/cube/cubescan.l ontrib/se ...

7. SQL Loader error: SQL*Loader-282

8. Extent chain logic.

9. Different Record Delimiter in SQL*Loader

10. SQL*Loader for loading multiple records

11. SQL*Loader ( and multi-line record

12. Using SQL Loader to add records to a table