troubleshooting Question

windows batch(.cmd) file

Avatar of GouthamAnand
GouthamAnand asked on
Oracle DatabaseMicrosoft Legacy OS
5 Comments1 Solution769 ViewsLast Modified:
Hi,

I have windows .cmd file which has oracle sqlplus command to spool the data and also oracle sqlldr commands to load the spooled data.
The data in the .cmd file is like in the attached file.

I want to set the connection string "abc/abc_dev@10.157.26.16:1522/mnop"
for oracle at one place instead of muliple times mention. Because like this sqlldr loading, I have many tables.

Can you please suggest?

thanks.
test.txt
ASKER CERTIFIED SOLUTION
David Johnson, CD
The More I know, the more I don't know
Join our community to see this answer!
Unlock 1 Answer and 5 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 5 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros