Home » RDBMS Server » Server Utilities » sqlload loading inverted values in oracle tables
sqlload loading inverted values in oracle tables [message #72199] Thu, 10 April 2003 00:05 Go to next message
Manoj
Messages: 101
Registered: August 2000
Senior Member
urgent pls reply,

I have a control file which will take infile as a text file and load its contents to an oracle table, but when its loading it loads the last line in text file as first entry in oracle table and so on. please help. my platform is PII and sco unix 5.0.2. oracle 7.2.

Report message to a moderator

Re: sqlload loading inverted values in oracle tables [message #72201 is a reply to message #72199] Thu, 10 April 2003 06:56 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
 
1. create a dummy table
   like the original table.
2. load your records using sqlloader to the dummy table
   ( just the regular way).
3. now
   insert into original ( select * from dummy order by rownum desc);
4. drop the dummy

Report message to a moderator

Re: sqlload loading inverted values in oracle tables [message #72209 is a reply to message #72199] Sat, 12 April 2003 04:59 Go to previous message
Barbara Boehmer
Messages: 9101
Registered: November 2002
Location: California, USA
Senior Member
The order in which records are inserted into an Oracle table is irrelevant. Even if you get them initially inserted in the order that you want, Oracle does not guarantee the order in which they are retrieved unless you specify an order by clause in a select statement. The only time order matters is when you are retrieving data.

Report message to a moderator

Previous Topic: using POSITION in a function
Next Topic: Loading Binary using SQL *Loader
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Tue Dec 24 08:18:35 CST 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.