This document was produced through funding of the National Science Foundation. Copyright (C) 1987, by the Board of Trustees of The University of Illinois. Permission to duplicate this document, in whole or part, is granted provided reference is made to the source and this copyright is included in whole copies.
This document assumes that one is familiar with the workings of a non-connected simple IP network (e.g. a few 4.2 BSD systems on an Ethernet not connected to anywhere else). Appendix A contains remedial information to get one to this point.
The Hitchhiker’s Guide to the Oracle9i Data Dictionary
The analyze command can be used to generate a listing of the chained rows within a table. This listing of chained rows can be stored in a table called CHAINED_ROWS. To create the CHAINED_ROWS table in your schema, run the utlchain.sql script (usually found in the /rdbms/ admin subdirectory under the Oracle home directory).
The Hitchhiker’s Guide to Database Administration
is actively used by the database is backed up. These files provide a complete image of the database as it existed at the moment it was shut down. NOTE You should not rely on an offline backup performed following a shutdown abort, since it may be inconsistent. If you must perform a shutdown abort, you should restart the database and perform a normal shutdown or a shutdown immediate or a shutdown transactional prior to beginning your offline backup.