jaffanajeffada Posted January 30, 2013 Report Posted January 30, 2013 [quote name='massmaharaj' timestamp='1359576044' post='1303202933'] i used the above eerror is /Scripts/proc.ksh[3]: sqlplus: not found [/quote] [color=#282828][font=helvetica, arial, sans-serif]$ORACLE_HOME define ayyi undha??[/font][/color] [color=#282828][font=helvetica, arial, sans-serif]echo [/font][/color][color=#282828][font=helvetica, arial, sans-serif]$ORACLE_HOME ante em vastondhi?[/font][/color] [color=#282828][font=helvetica, arial, sans-serif]SQLPLUS anedhi [/font][/color][color=#282828][font=helvetica, arial, sans-serif]$ORACLE_HOME/bin lo untundhi[/font][/color][color=#282828][font=helvetica, arial, sans-serif] [/font][/color]
SudhirKumar Posted January 30, 2013 Report Posted January 30, 2013 [quote name='Aamphat' timestamp='1359569789' post='1303202003'] thread esinodu kaneesam..solve aindhoo ledhoo kuda cheppakapotey ela vaay. ninna edo thread lo annatu.. 90% db ppl use and throw type anattu untaaru ani... looks like it is true [/quote] Agreed
massmaharaj Posted January 30, 2013 Author Report Posted January 30, 2013 yeah [size=4]echo $ORACLE_HOME ante [/size] [size=4]idhi vachindhi [/size] /apps/orcl01/oracle/product/11.2.0/client_1
jaffanajeffada Posted January 30, 2013 Report Posted January 30, 2013 [quote name='massmaharaj' timestamp='1359576958' post='1303203085'] yeah [size=4]echo $ORACLE_HOME ante [/size] [size=4]idhi vachindhi [/size] /apps/orcl01/oracle/product/11.2.0/client_1 [/quote] naaku work avutondhi baa this is what i have done 1. Create a test.sql file with below content spool /home/abc.txt select * from dual; spool off exit 2. run below in unix terminal $ORACLE_HOME/bin/sqlplus -s UID/PASSWORD@DBNAME @test.sql a file with abc.txt is created
massmaharaj Posted January 30, 2013 Author Report Posted January 30, 2013 oh i did not try this way do you have your name can you pm i can call you please
massmaharaj Posted January 30, 2013 Author Report Posted January 30, 2013 [color=#282828][font=helvetica, arial, sans-serif]spool /home/abc.txt[/font][/color] [color=#282828][font=helvetica, arial, sans-serif]select * from dual;[/font][/color] [color=#282828][font=helvetica, arial, sans-serif]spool off[/font][/color] [color=#282828][font=helvetica, arial, sans-serif]exit[/font][/color] [color=#282828][font=helvetica, arial, sans-serif][size=4]the above 4 lines where should i put[/size][/font][/color]
jaffanajeffada Posted January 30, 2013 Report Posted January 30, 2013 [quote name='massmaharaj' timestamp='1359578021' post='1303203275'] oh i did not try this way do you have your name can you pm i can call you please [/quote] i am unable to send PM to you
jaffanajeffada Posted January 30, 2013 Report Posted January 30, 2013 [quote name='massmaharaj' timestamp='1359578100' post='1303203288'] [color=#282828][font=helvetica, arial, sans-serif]spool /home/abc.txt[/font][/color] [color=#282828][font=helvetica, arial, sans-serif]select * from dual;[/font][/color] [color=#282828][font=helvetica, arial, sans-serif]spool off[/font][/color] [color=#282828][font=helvetica, arial, sans-serif]exit[/font][/color] [color=#282828][font=helvetica, arial, sans-serif][size=4]the above 4 lines where should i put[/size][/font][/color] [/quote] [color=#282828][font=helvetica, arial, sans-serif]1. Create a test.sql file with below content in your local folder on unix box.[/font][/color] [color=#282828][font=helvetica, arial, sans-serif]also note [/font][/color][color=#282828][font=helvetica, arial, sans-serif]/home/abc.txt[/font][/color][color=#282828][font=helvetica, arial, sans-serif] should map to some local folder in your unix box where your id have write priveleges[/font][/color]
massmaharaj Posted January 30, 2013 Author Report Posted January 30, 2013 i will try out the aboev way
Recommended Posts