Oracle

From Federal Burro of Information
Revision as of 22:50, 6 January 2012 by David (talk | contribs)
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to navigationJump to search

Archive log

how to setup:

http://www.beyondoracle.com/2008/05/08/setup-oracle-database-archivelog-mode/

sql plus:

shutdown immediate;
startup mount;
alter database archivelog;
alter database open;

examine:

archive log list;
select log_mode from v$database;

Other tips

/sqlplus help

Quick tour http://docs.oracle.com/cd/B19306_01/text.102/b14217/quicktour.htm

mysql's \G vertical output: https://forums.oracle.com/forums/thread.jspa?threadID=923884

sqlplus for windows - setting it up right http://www.williamrobertson.net/documents/sqlplus-setup.html

formatting output http://blog.tanelpoder.com/2007/08/07/sqlplus-is-my-second-home-part-1-htmlizing-your-sqlplus-output/