STOP
This topic is NOT up for debate.
If you proceed to write and respond with unsupportive and baseless arguments, then consider yourself banned and or ignored.
Whichever comes first...
To start off, I'd like to point out that I am a complete beginner when it comes to using Oracle & SQL. I'm currently attending a local community college that has required me to take a database class for my intended major and whatnot. So, long story short, I had to use Oracle 11g Express for one of my homeworks'.
I had used the command line (SQL) for the first time on campus and was shown how to log-on via my instructor's instructions, which revealed to me that it wasn't all that big of a deal—or so I thought.
Class ended, and I got home. Started up my SQL command prompt, and tried to log-on using the credentials I had while I was on campus. That failed. I then came to the conclusion and realization that I could not in fact use the same credentials, so I then wondered what it was that I had to type in as my user and pass. Keep in mind, I had no idea what those were at the time either. So, as most people would do in this situation, I turned to Google. I found one related forum post on this very site, which showed pitiful responses to the op. I was disappointed. Nonetheless, I was given some insight. Just a little. So, after another 10-20 minutes of looking around, I had found something. The people had suggested logging on as SYSTEM, which I for whatever reason felt like I had done so before. So, I logged on as SYSTEM with the password I had given Oracle during installation. I was finally "connected".
Next, I wanted to open an SQL file I had downloaded from my college's partner site. So, I unzipped the file, extracted it to My Documents, and selected the option "open command line here" from the folder that contained the SQL file. Now the DOS prompt was opened in the directory containing the file, and I ran the statement "sqlplus SYSTEM/pass < filename.sql". I didn't write it word for word like that... but you get it (I hope). After 5 attempts, I was given the same result: "The system cannot find the file specified".
So, after no results and limited references on the web, I decided to come onto this site and hopefully get my question(s) answered. What am I doing wrong?
Additional Information:
*I'm using Windows 8.1.
*I don't know why I was instructed to use both SQL command prompt and DOS command prompt for the exercise. I'm assuming there's a good reason...
*The SQL file I mentioned is in fact in the correct location and directory. I double checked.
So, once more, I'd like to warn those of you who feel the need to lecture me and give me a heap-load of useless batter:
I do not tolerate those who purposely give others a hard time for not knowing a certain subject. Last time I checked, we all grew up not knowing a thing or two.
So, either get over yourself, or leave this post. If you have no business with this matter and only intend to respond with negative feedback, save yourself the trouble and bother someone else. I'm telling you this now because I'll literally just ignore you. It's one of my better qualities (I think). Seriously, go away.
This thread's sole purpose is the disclosure & assessment of the subject at hand.
Thanks for reading,
Bryan