OraFAQ Forum: Server Utilities

Home » RDBMS Server » Server Utilities » SQL Loader (Oracle 11g, Forms11g)

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

SQL Loader [message #669997]

Tue, 29 May 2018 02:35

AyeshaSaad
Messages: 16
Registered: December 2016

Junior Member

Dear ALL
We want to facilitate remote users to load his/her DMP files in oracle 11g server but how to use SQL LOADER in my application?
Anybody please guide me.

Report message to a moderator

Re: SQL Loader [message #669998 is a reply to message #669997]

Tue, 29 May 2018 04:07

John Watson
Messages: 8997
Registered: January 2010
Location: Global Village

Senior Member

What is the format of these "DMP" files? That is a suffix usually used to indicate a Data Pump export file, which you cannot read with SQL*Loader.

Report message to a moderator

Re: SQL Loader [message #670001 is a reply to message #669998]

Tue, 29 May 2018 04:42

gazzag
Messages: 1119
Registered: November 2010
Location: Bedwas, UK

Senior Member

SQ*Loader.

Report message to a moderator

Re: SQL Loader [message #670002 is a reply to message #670001]

Tue, 29 May 2018 06:17

AyeshaSaad
Messages: 16
Registered: December 2016

Junior Member

I know I have to SQL LOADER but I want to know the procedure, how to use?

Report message to a moderator

Re: SQL Loader [message #670003 is a reply to message #670002]

Tue, 29 May 2018 06:28

EdStevens
Messages: 1377
Registered: September 2013

Senior Member

AyeshaSaad wrote on Tue, 29 May 2018 06:17

I know I have to SQL LOADER but I want to know the procedure, how to use?

Gazzag gave you a link to the documentation for SQL*Loader. What more do you need to know "how to use?".

Report message to a moderator

Re: SQL Loader [message #670004 is a reply to message #670002]

Tue, 29 May 2018 06:32

gazzag
Messages: 1119
Registered: November 2010
Location: Bedwas, UK

Senior Member

Why don't you look at the documentation at the link I sent you. Try something yourself, then come back with any questions you might have. Folks here are happy to help anyone who has made an effort.

Report message to a moderator

Re: SQL Loader [message #670010 is a reply to message #669997]

Tue, 29 May 2018 08:32

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

AyeshaSaad wrote on Tue, 29 May 2018 00:35

Dear ALL
We want to facilitate remote users to load his/her DMP files in oracle 11g server but how to use SQL LOADER in my application?
Anybody please guide me.

Answer depends upon exactly how & what actually made the *DMP file.

Please read and follow the forum guidelines, to enable us to help you:
OraFAQ Forum Guide
How to use {code} tags and make your code easier to read

Report message to a moderator

Previous Topic:	ORA-01722
Next Topic:	External Table

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon Mar 02 11:18:31 CST 2026