OraFAQ Forum: Server Utilities

Home » RDBMS Server » Server Utilities » SQL* Loader

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

SQL* Loader [message #290780]

Mon, 31 December 2007 14:32

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

Report message to a moderator

Re: SQL* Loader [message #290785 is a reply to message #290780]

Mon, 31 December 2007 14:44

Michel Cadot
Messages: 68665
Registered: March 2007
Location: Nanterre, France, http://...

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

Report message to a moderator

Re: SQL* Loader [message #290790 is a reply to message #290780]

Mon, 31 December 2007 15:21

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?

Report message to a moderator

Re: SQL* Loader [message #290792 is a reply to message #290790]

Mon, 31 December 2007 15:42

Michel Cadot
Messages: 68665
Registered: March 2007
Location: Nanterre, France, http://...

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

Report message to a moderator

Previous Topic:	Data loading
Next Topic:	Loading variable and fixed data

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat Jun 29 05:43:09 CDT 2024