DBA Scripts

• oratop
  OraTop provides a unix-top like display for Oracle.
  
  
• Advance Oraenv (aoe)
  A menu driven oraenv.
  
  
• table_conf.sql
  Display information about the specified table. Size, rows, partitions, indexes, constraints and triggers.
  
  
• user_conf.sql
  Show a users configuration (default tablespace, grants, roles, etc...)
  
  
• user_clone.sql
  Clone a user. This doesn't clone objects owned by the user - just the user itself.
  
  
• user_drop_objs.sql
  Drop all objects belonging to the specified user, but leave the user.
  
  
• user_truncate_objs.sql
  Truncates all tables that belong to the specified user.
  
  
• login.sql
  Place this script in your $ORACLE_HOME/bin to set the sqlplus prompt to 'user@database>'.
  
  
• become_user.sql
  When run as sys, this script will allow you to log in as any user in the database - without needing to know the password.