Home » RDBMS Server » Server Utilities » SQL*LOADER
SQL*LOADER [message #112830] Tue, 29 March 2005 10:27 Go to next message
pravisri
Messages: 10
Registered: March 2005
Location: Manchester
Junior Member
How to write SQL*LOADER control file for specifying the TABLE NAME dynamically ? Is this possible ?

Many Thanks & Regards
Srinivas

Report message to a moderator

Re: SQL*LOADER [message #112834 is a reply to message #112830] Tue, 29 March 2005 10:43 Go to previous message
Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
a little scripting should help.

many methods are available.
Please have a look here
almost the same case. all you need to do is dynamically create the control file from template control file.

http://www.orafaq.com/forum/t/26733/0/

and search this forum for more.

Report message to a moderator

Previous Topic: Why no body answer , me is it difficult?
Next Topic: UTL_FILE problem - getting file in ascii format
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Wed Jul 03 07:40:15 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.