Oracle Developer Jr - READY TO HIRE! Next Step Systems US-CA-Thousand Oaks Post A Job | Post A Resume

• Compile all PACKAGES,PROCEDURES and FUNCTIONS on ORACLE - This scripts compiles all packages,procedures and functions on ORACLE database. (Added: 24-Aug-2000 Hits: 7046 Rating: 5.89 Votes: 9) Rate It

• Create the Control File - This is brief information about control file.
  Take the controlfile information from trace file and does changes accordingly. (Added: 14-Jun-2004 Hits: 4042 Rating: 0 Votes: 0) Rate It

• createpartitions.ksh - This script can be used to create partions as well as indexes for these in a single run.It calls the following scripts:
  
  1.tablespace_size_stat.sql
  2.select_partition_table.sql
  3.create_partition_tablespace.sql
  4.add_partition.sql
  5.create_ind_partition_tablespace.sql
  6.rebuild_partition_index.sql (Added: 15-May-2006 Hits: 2428 Rating: 5.50 Votes: 2) Rate It

• Database Lock Information - Unix shell script (Solaris)that looks for Object Name and for how long the Lock has been there (Locked Time in Sec). If necessary the DBA may need to kill the session/process. (Added: 30-Sep-2004 Hits: 3020 Rating: 5.00 Votes: 1) Rate It

• Database Physical & Actual Size - Useful on Oracle 8.1.7 onwards or remove the dba_temp_files line & run for earlier versions. (Added: 23-Feb-2006 Hits: 2346 Rating: 0 Votes: 0) Rate It

• Database Startup - This shell script is useful to startup a database when it must be running.
  It checks the database status based on value of status (Y|N) in the
  /etc/oratab file and send an e-mail to DBA when database has been restarted.
  It works fine in Red Hat Linux boxes. (Added: 21-Oct-2003 Hits: 4120 Rating: 0 Votes: 0) Rate It

• Database Tables Comparison Script - This script compares tables in different databases across a remote link. It is written using dbms_sql.describe and is very quick and can easily be turned into a package for schema comparisons. (Added: 10-Dec-2001 Hits: 4226 Rating: 0 Votes: 0) Rate It

• Disable or enable all constraints in user - This script disables or enables all constraints in user of your choice. (Added: 18-Apr-2003 Hits: 2420 Rating: 0 Votes: 0) Rate It

• Displays information about scheduled jobs - Displays information about scheduled jobs including number of failures, execution and interval information (Added: 31-May-2000 Hits: 5411 Rating: 7.43 Votes: 7) Rate It

• Email Validation - This procedure returns 0 if invalid mail ID else 1. (Added: 6-May-2005 Hits: 2167 Rating: 4.50 Votes: 2) Rate It

Prev 10 Next 10