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
Log / trace files
Database
Tablespace
Datafile
Table
User management
Usage checking
Oracle statistics
Import & Export
Backup & Restore
Rman, cloning
Standby database on standard edition
Applying CPU patch
Express Edition
10g specific
Oracle 10g Enterprise Manager
Oracle ASM
Database Suspend
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.
Show running SID in sqlplus
select instance from v$thread;
There are no comments on this page. [Add comment]