Oracle: Difference between revisions

From Federal Burro of Information
Jump to navigationJump to search
No edit summary
No edit summary
Line 22: Line 22:


mysql's \G vertical output: https://forums.oracle.com/forums/thread.jspa?threadID=923884
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

Revision as of 22:39, 6 January 2012

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;

/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