|
-
Dear DBA's
I require your advise regarding running SQL*LOADER continuecely for multiple Tables. I have have created seprate Control file, Datafile for each table. now this I want to insert into Oracle through SQL*LOADER for that I do
SQLLDR userid=USERNAME/PASS@DB DIRECT=TRUE control=TABLENAME.CTL log=TABLENAME.LOG ERRORS=10000000
this works properly. But every time I have to execute this command line by changing different TABLENAME control file and log file. So every time there will be login. Can I avoid this and execute SQLLDR only once for all controlfiles. Please Help.
Thanks & Regards
Shailesh
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|