Oracle: Difference between revisions
From Federal Burro of Information
Jump to navigationJump to search
No edit summary |
No edit summary |
||
| Line 16: | Line 16: | ||
archive log list; | archive log list; | ||
select log_mode from v$database; | select log_mode from v$database; | ||
== Other tips == | |||
[[/sqlplus help]] | [[/sqlplus help]] | ||
| Line 24: | Line 26: | ||
sqlplus for windows - setting it up right http://www.williamrobertson.net/documents/sqlplus-setup.html | 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/ | |||
Latest revision as of 22:50, 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;
Other tips
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/
