I installed Oracle 8.0.5 on Red Hat Linux6.0 according to the notes at
http://jordan.fortwayne.com/oracle/rh6x.html
I have some questions. Some are UNIX-related.
- What's the password for the users Adams etc. in the sample database.
I know it's tiger for Scott.
- How can I press the UP arrow to show previous commands at the SQL>
prompt? When I press UP, it shows ^[[A.
- My stty is set correctly at shell prompt but not in SQL*Plus. Every
time I get into SQL*Plus, I have to type "host stty erase ^H" to use
Backspace to delete.
- "help" (or anything like "help select") in SQL*Plus is not
available. I followed the above-said instruction to install Oracle
documentation.
- A UNIX question. Every time I logon to UNIX either as root or oracle
or me, ~/.profile is not run automatically (shell is bash). So I have
to manually ". .profile" every time I open a terminal window.
- Is it possible to move Scott's tables from SYSTEM tablespace to
USERS tablespace? ALTER TABLE seems to have the keyword TABLESPACE in
its clause together with PARTITION. I wonder if I have to export and
import.
Thanks very much for help.
Yong Huang
Email:yong321_at_yahoo.com
Sent via Deja.com http://www.deja.com/
Share what you know. Learn what you don't.
Received on Fri Jul 23 1999 - 13:15:51 CDT