Running a script in command line
894131Oct 12 2011 — edited Oct 12 2011Hi all
Firstly id like to say I am just starting ORACLE 11g with no prior database experience. i currently have lectures once a week. I am however stuck with a problem. I am trying to access my uni database from home so i can do some work, apparently i can only access it via command prompt (wich is fine by me) I started by downloading a secure shell at www.putty.org and i managed to log on to my university test database from my laptop at home. However, i have a script file createHR.sql which is stored in my C:\ORACLE directory wich i am trying to access so i can load my test tables and start practising with them.
i use at command line
SQL> C:\ORACLE\createHr and i get SP2-0310:unable to login to file "C:\ORACLE\create HR.sql"
normally this should load and execute the script – as with the browser method prompts will indicate that tables are being created and test data added.
I am now officially fustrated as i cannot get any practise done, any help offered will be most welcome.
Regards
Claude
Edited by: 891128 on 12-Oct-2011 09:33
Edited by: 891128 on 12-Oct-2011 09:41
Edited by: 891128 on 12-Oct-2011 09:44