Untitled Document

CS145 - Summer 2006
Introduction to Databases

Project Part 0 Questions and Answers

Q: Leland machine says "sqlplus: Command not found."
A: Make sure your environment variables are setup properly by running
```
	source /afs/ir/class/cs145/all.env
  
```
Note that when you try to record your session with "script", it will start a new shell -- requiring you to reload the environment variable. You can put the "source ..." line in your .cshrc file to automatically load the environment variables.
Q: When bulk loading, sqplus generates an error of `unknown command "load data"`
A: The Oracle bulk loader is a separate program outside of sqlplus. Run the bulk loader from the shell command prompt
Q: When trying to change my password, I type in
```
alter user MYUSERNAME identified by MYPASSWORD;
```
and I get the error
```
ERROR at line 1:
ORA-00988: missing or invalid password(s)
```
A:Whatever you entered for MYPASSWORD cannot contain spaces or start with a number.
Q: sqlldr generates an error of "Illegal combination of non-alphanumeric characters: INFILE /afs/ir/class/cs145/sample_data/Courses.txt"
A: The INFILE name in the control file must be in quote, single or double.
Q: sqlldr generates an error of "Error during describe of table COURSES, ORA-04043: object COURSES does not exist"
A: You must create the table in sqlplus first before you can bulk load into the table.