Shell Script
A reader, March 28, 2017 - 6:17 am UTC
would you explain what benefits we get if we use Shell script to call sql loader.
March 28, 2017 - 12:20 pm UTC
It wont impact SQL Loader, but you probably want to have something once SQL loader runs that
- checks to see if the load worked
- looks for oracle errors
- compares rows input with rows loaded
etc etc...
You could do it manually...but you'd probably ultimately want to automate that - and a shell script is good for that.
Documentation
santhoshreddy podduturi, May 05, 2017 - 4:28 am UTC
Is there any oracle documentation or any other resources explaining about shell script to load data? if there please give me.
May 09, 2017 - 2:23 am UTC
Search for "sqlldr" on this site, there will be plenty of examples
Fix the Bug
A reader, May 09, 2017 - 8:53 am UTC
Hi conor,
when i searched with sqlldr text the GO buttn getting Disabled,worked fine with doublequotes "sqlldr" please fix this bug.
i found so many questions regarding loading Data But not exactly what i am looking for.
I need to Help me
A reader, July 04, 2020 - 5:49 pm UTC
I'm run my work in server, i need of script shell linux for export data (table ) from oracle sql developer to server form file.txt for exemple.
Thanks
Help me
moha, July 04, 2020 - 5:54 pm UTC
Hi, thanks for your best script. i run my work in server, i need of script shell linux for import data (Table) from oracle sql developer to server form file.txt for exemple
July 06, 2020 - 5:42 am UTC
Not sure what you mean, but perhaps something like
#!/bin/ksh
export ORACLE_HOME=...
export ORACLE_SID=...
export PATH=$ORACLE_HOME/bin:$PATH
print "
connect scott/tiger
set markup csv on
set pages 0
set lines 1000
set trimspool on
select * from mytable;" | sqlplus -s /nolog 1>/tmp/file.out 2>&1