TABLESPACE FILES
    Note that files get created a little larger than the values you specify
     in CREATE TABLESPACE... DATAFILE.
    dba_data_files
        status is just whether available
        maxbytes has nothing to do with current size
        bytes seems to always be > user_bytes, but is still a little
         lower than the actual file size.  (Therefore, "bytes" is 
         probably better for general user).
        The "bytes" value is exactly that specified in the database clause
         of CREATE TABLESPACE.

exp
    There's a newer, preferred program for expors/imports.  *pump*?
    In Oracle's examples, they love to specify settings which are the defaults.
    Why in hell waste time specifying settings which are defaults?!!!!
    exp blake/paper FILE=blake.exp 'TABLES=(dept, manager)'
    Useful exp switches:
        FILE
        OWNER
        TABLES
        LOG
        FULL  (says that requires EXP_FULL_DATABASE role, but DBA works?)
    Useful imp switches:
        FILE
        FROMUSER
        TOUSER
        TABLES
        LOG
        FULL
        IGNORE
        STATISTICS=recalculate
        SHOW (no-run mode)
    Defaults are: ROWS=y COMPRESS=y GRANTS=y (no log file)
    FULL backup: 
        exp dbaacct/pwd FILE=db.exp FULL=y
N.b. an full import will create tablespaces if they don't already exist.
So, if you want them created with different file paths, or anything else,
create them before doing the import.
Put database in NOARCHIVELOG mode until full imports complete.
exp blaine/losung1 FILE=/dev/stdout FULL=y | bzip2 -c |
dd bs=1M of=eits-test.exp.bz2
(bunzip2 -c eits-test2.exp.bz2 |
    imp blaine/blaine SHOW=y FILE=/dev/stdin FULL=y)
bunzip2 -c eits-test2.exp.bz2 |
    imp blaine/blaine LOG=eits2-imp.log FILE=/dev/stdin FULL=y IGNORE=y STATISTICS=recalculate
?????  For some reason the /dev/stdin only works as oracle, not as "bsimpson"???


When use dbca to create a database, can write a copy of creation scripts to
$ORACLE_HOME/admin/$ORACLE_SID/scripts.
I'm tring setting both max_roles and max_enabled roles in init*.ora
doing an import, in order to avoid the 30 enabled roles exceeded errors.
Dbca DB creation generates non-fatal error 
"Specified operator does not exist".  If you get this, execute
$ORACLE_HOME/rdbms/admin/prvtxml.plb as SYS after dbca completes.

Turning on/off archivelog mode and settings.
http://www.dbaoncall.net/references/ht_archive_mode.html
BETTER:  http://www.orafaq.com/forum/t/45847/0/