Import tables from a txt 3

[NiteCrawlr]

HELP!!!

My problem is kinda easy but I don't have a least idea of how to do it, I have a Script file (txt) where there is some data where I want to put them in a Oracle table, how do I do it?
What is the easiest way to do that??

Thanks

Frederico

 

[tkjames]

Depends on what is the format of the txt file. Do you want to put each line of the txt file to the table or only a part of the line? You need to show a sample

 

[NiteCrawlr]

The txt was generated from the same table but it was from SQL Server, they both have the same type of format, I'm just importing the info from the SQL Server.

Obs: The SQL Server is in another computer.

 

[stevecal]

The easiest way to do this is with SQLLDR80.exe. It allows you to schedule uploads from text files in the way you wish your payload to be delivered.

 

[seagull69]

Another tip if the data volume is not high: generate a script with insert's from sql-server and then execute it in sql*plus (oracle side). Don't forget to set autocommit 100 (or so) to go smoothly.

HTH

seagull69