This content has been marked as final. Show 15 replies
karthiksingh_india wrote:SQL> @BATCH_LOAD.SQL
I want to create Multiple table at a single stroke in oracle sql developer or sql*plus using any mode like batch file or sql files...
I dont know the exact mode and how to create it please guide me..I want to learn more about this since am a DBA Beginner..
Any kind of help would be appreciated more...Thanks in Advance
According to your suggestion I did everything and all works fine yesterday... But today the same script.bat file is not opening sqlplus...
as soon as I double click the bat file it opens the prompt and it shows upto the copyright ..oracle all rights reserved. sql> prompt is not visible or upto that it strucks... please help me..
sqlplus scott/tiger@VESS @test.sql
select * from tab;
Please help me...
Now it's working...I have changed the script.bat by editing the SID name which I have given in the line
sqlplus scott/tiger@VESS @test.sql and I replaced it as
sqlplus scott/tiger @test.sql
and now it works fine...
Now the problem is I want to write a batch or script that will make a login to the sqlplus without any username or password Please help me it needed for our technical team since am a DBA beginner..
Thanks for all who replied...I want to learn more in Oracle DBA
Create sql script file test.sql containing
Next, create a batch file called "C:\test.bat" containing the following command.
sqlplus /nolog @C:\test.sql
The resulting batch file can be run manually, by double-clicking on it.
I dont think it is possible to create a batch file to connect to db using SQL Developer since it is a graphical interface.
Edited by: mBk77 on Apr 26, 2012 12:35 PM
Can anyone Please help me in writing a perfect shell script to LOGIN to our LINUX server to login to sqlplus... Please help me..
As far as I have tried something
sqlplus /nolog@db_name @test1.sql
select * from tab;
After this what should be done..Please help me Legends, I wanna learn more..