Oracle7-style backups with awk.
DDL extractor (Korn shell script).
Useful for moving tables with LONG columns
(or moving any tables at all in v7, which lacks "ALTER TABLE MOVE").
Uses import/export to get table and index definitions,
then SQL to get grants, triggers, and comments. It will not extract views
(as they are not dropped when the table is dropped), and it will not disable
any foreign key constraints. Best if the script is saved as "ADDLE" (for
clarity of directory listings).
Utility (requires ksh93) for concealing passwords from ps -ef reports.
Extracts the list of Oracle users from DBA_USERS, and attempts to login to
each account using a password specified at runtime. If no password is
specified, it attempts to login with a password that is the same as the
username.
Oracle alert log scanner. Brute force approach, written in awk. Requires the
gnu date utility. Details in the script.
Revised alert log scanner, using GNU AWK's time extensions. Slightly different
syntax.
Shrink all your rollback segments.
List all datafiles for tablespaces that are over 90% full.
Create an 8i database using LMTs for everything (including rollback).
This script must be edited (change SID, datafile locations). The init.ora
must also have "compatible = 8.1.0" to use these features.
Create a 9i database.
This script must be edited (change SID, datafile locations). The init.ora
must also have UNDO settings
in place (undo_management=auto, undo_tablespace=undo,
undo_retention=86400), and the "compatible" parameter
must be set to at least "9.0.0"
("9.2.0" may be a better choice).
Helpful security steps, gained from past exposure to audits and automated
security scanners.
Oracle's to_number function returns ORA-01722: invalid number upon finding
non-numeric characters in a string. This function will return NULL when
such characters are found, and otherwise will perform the to_number.