Additions:
Additions:
Additions:
Show running SID in sqlplus
select instance from v$thread;
Additions:
SQLplus with history!
Install rlwrap
http://freshmeat.net/projects/rlwrap∞
alias sqlplus='/usr/bin/rlwrap -m ${ORACLE_HOME}/bin/sqlplus'
There you go, you can now use the arrow key to access the historic commands, like in bash.
Additions:
Additions:
Additions:
Additions:
Additions:
Additions:
Deletions:
Additions:
Deletions:
Information on Oracle
What I remember from the Oracle trainning...
Oracle Database is made up of Schema(s), which contains Tablespace(s), which contains Table(s), which are stored on Datafile(s). Datafile(s) are made up of database Block(s), which can be multiples of filesystem blocks. Don't remember where Partition(s) fits in.
[
Installation]
[
Control, Init files]
[
Database]
[
Tablespace]
[
Datafile]
[
Table]
[
User management]
[
Usage checking∞]
[
Oracle statistics]
[
Import & Export]
[
Backup & Restore]
[
Rman, cloning]
[
Standby database on standard edition]