Home » RDBMS Server » Server Utilities » SQL* Loader
SQL* Loader [message #290780] Mon, 31 December 2007 14:32 Go to next message
susuOra
Messages: 10
Registered: December 2007
Location: USA
Junior Member
Hey,
I have a question about SQL* Loader, is there a difference between it and inserting statements with an SQL script? When I would use each one.

Thanks,
Susu
Re: SQL* Loader [message #290785 is a reply to message #290780] Mon, 31 December 2007 14:44 Go to previous messageGo to next message
Michel Cadot
Messages: 68728
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
INSERT can't insert file just values in statement.
INSERT with values can't use DIRECT PATH.
INSERT with values can't use PARALLEL.
And so on.

Regards
Michel
Re: SQL* Loader [message #290790 is a reply to message #290780] Mon, 31 December 2007 15:21 Go to previous messageGo to next message
susuOra
Messages: 10
Registered: December 2007
Location: USA
Junior Member
Thanks for replying me.
So is there a situation I need to use one way over the other way?
Re: SQL* Loader [message #290792 is a reply to message #290790] Mon, 31 December 2007 15:42 Go to previous message
Michel Cadot
Messages: 68728
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
If you load a file, use SQL*Loader.
I don't understand the question.
In the end, you have no choice.
Either you have a file (like a CSV one) either you have statements. You use what you have.

Regards
Michel
Previous Topic: Data loading
Next Topic: Loading variable and fixed data
Goto Forum:
  


Current Time: Tue Dec 24 23:48:33 CST 2024