Full Dba Scripts

http://www.high-oracle.com/scripts/

Script: dba_directories.sql
Script: dba_controlfile_records.sql
Script: dba_blocks_used_by_table.sql
Script: dba_cr_init.sql
Script: dba_compare_schemas.sql
Script: dba_column_constraints.sql
Script: dba_controlfiles.sql
Script: dba_db_growth.sql
Script: awr_snapshots_dbtime.sql
Script: dba_errors.sql
Script: dba_file_space_usage.sql
Script: dba_file_space_usage_7.sql
Script: dba_file_use.sql
Script: dba_file_use_7.sql
Script: dba_files.sql
Script: dba_files_all.sql
Script: dba_free_space_frag.sql
Script: dba_highwater_mark.sql
Script: dba_index_fragmentation.sql
Script: dba_index_schema_fragmentation_report.sql
Script: dba_index_stats.sql
Script: dba_invalid_objects.sql
Script: dba_invalid_objects_summary.sql
Script: dba_jobs.sql
Script: dba_object_cache.sql
Script: dba_object_search.sql
Script: dba_object_summary.sql
Script: dba_options.sql
Script: dba_owner_to_tablespace.sql
Script: dba_plsql_package_size.sql
Script: dba_query_hidden_parameters.sql
Script: dba_random_number.sql
Script: dba_rebuild_indexes.sql
Script: dba_recompile_invalid_objects.sql
Script: dba_registry.sql
Script: dba_related_child_tables.sql
Script: dba_row_size.sql
Script: dba_segment_summary.sql
Script: dba_snapshot_database_8i.sql
Script: dba_snapshot_database_9i.sql
Script: dba_snapshot_database_10g.sql
Script: dba_table_info.sql
Script: dba_tables_all.sql
Script: dba_tables_current_user.sql
Script: dba_tables_query_user.sql
Script: dba_tablespace_mapper.sql
Script: dba_tablespace_to_owner.sql
Script: dba_tablespaces.sql
Script: dba_tablespaces_7.sql
Script: dba_tablespaces_8i.sql
Script: dba_top_segments.sql
Script: dpump_jobs.sql
Script: dpump_progress.sql
Script: dpump_sessions.sql
Script: erp_conc_manager_job_status.sql
Script: erp_conc_manager_job_status2.sql
Script: erp_conc_manager_user_query.sql
Script: example_create_clob.sql
Script: example_create_dimension.sql
Script: example_create_emp_dept_custom.sql
Script: example_create_emp_dept_original.sql
Script: example_create_index.sql
Script: example_create_index_organized_table.sql
Script: example_create_materialized_view.sql
Script: example_create_not_null_constraints.sql
Script: example_create_primary_foreign_key.sql
Script: example_create_profile_password_parameters.sql
Script: example_create_profile_resource_parameters.sql
Script: example_create_resource_plan_multi_resource_plan_9i.sql
Script: example_create_sequence.sql
Script: example_create_table.sql
Script: example_create_table_buffer_pools.sql
Script: example_create_tablespace.sql
Script: example_create_temporary_tables.sql
Script: example_create_user_tables.sql
Script: example_database_resource_manager_setup.sql
Script: example_drop_unused_column.sql
Script: example_lob_demonstration.sql
Script: example_move_table.sql
Script: example_partition_range_date_oracle_8.sql
Script: example_partition_range_number_oracle_8.sql
Script: example_transport_tablespace.sql
Script: fdb_log_files.sql
Script: fdb_redo_time_matrix.sql
Script: fdb_status.sql
Script: fra_alerts.sql
Script: fra_files.sql
Script: fra_status.sql
Script: help.sql
Script: lob_dump_blob.sql
Script: lob_dump_clob.sql
Script: lob_dump_nclob.sql
Script: lob_fragmentation_user.sql
Script: locks_blocking.sql
Script: locks_blocking2.sql
Script: locks_dml_ddl.sql
Script: locks_dml_lock_time.sql
Script: mts_dispatcher_status.sql
Script: mts_dispatcher_utilization.sql
Script: mts_queue_information.sql
Script: mts_shared_server_statistics.sql
Script: mts_shared_server_utilization.sql
Script: mts_user_connections.sql
Script: owi_event_names.sql
Script: perf_db_block_buffer_usage.sql
Script: perf_explain_plan.sql
Script: perf_file_io.sql
Script: perf_file_io_7.sql
Script: perf_file_io_efficiency.sql
Script: perf_file_waits.sql
Script: perf_hit_ratio_by_session.sql
Script: perf_hit_ratio_system.sql
Script: perf_log_switch_history_bytes_daily_all.sql
Script: perf_log_switch_history_count_daily.sql
Script: perf_log_switch_history_count_daily_7.sql
Script: perf_log_switch_history_count_daily_all.sql
Script: perf_lru_latch_contention.sql
Script: perf_objects_without_statistics.sql
Script: perf_performance_snapshot.sql
Script: perf_redo_log_contention.sql
Script: perf_sga_free_pool.sql
Script: perf_sga_usage.sql
Script: perf_shared_pool_memory.sql
Script: perf_top_10_procedures.sql
Script: perf_top_10_tables.sql
Script: perf_top_sql_by_buffer_gets.sql
Script: perf_top_sql_by_disk_reads.sql
Script: plsql_random_numbers.sql
Script: plsql_webdba_utl_pkg.sql
Script: rac_instances.sql
Script: rc_databases.sql
Script: rman_backup_pieces.sql
Script: rman_backup_sets.sql
Script: rman_backup_sets_8i.sql
Script: rman_configuration.sql
Script: rman_controlfiles.sql
Script: rman_progress.sql
Script: rman_spfiles.sql
Script: rollback_segments.sql
Script: rollback_users.sql
Script: rsrc_plan_status_detail.sql
Script: rsrc_plan_status_summary.sql
Script: sec_default_passwords.sql
Script: sec_users.sql
Script: sess_current_user_transactions.sql
Script: sec_roles.sql
Script: sess_query_sql.sql
Script: sess_uncommited_transactions.sql
Script: sess_user_sessions.sql
Script: sess_user_stats.sql
Script: sess_user_trace_file_location.sql
Script: sess_users.sql
Script: sess_users_8i.sql
Script: sess_users_active.sql
Script: sess_users_active_8i.sql
Script: sess_users_active_sql.sql
Script: sess_users_by_cpu.sql
Script: sess_users_by_cursors.sql
Script: sess_users_by_io.sql
Script: sess_users_by_memory.sql
Script: sess_users_by_transactions.sql
Script: sess_waiting.sql
Script: sess_waiting_8i.sql
Script: sp_auto.sql
Script: sp_auto_5.sql
Script: sp_auto_15.sql
Script: sp_auto_30.sql
Script: sp_list.sql
Script: sp_parameters.sql
Script: sp_purge.sql
Script: sp_purge_30_days_9i.sql
Script: sp_purge_30_days_10g.sql
Script: sp_purge_n_days_9i.sql
Script: sp_purge_n_days_10g.sql
Script: sp_snap.sql
Script: sp_statspack_custom_pkg_9i.sql
Script: sp_statspack_custom_pkg_10g.sql
Script: sp_trunc.sql
Script: temp_sort_segment.sql
Script: temp_sort_users.sql
Script: temp_status.sql
Script: undo_contention.sql
Script: undo_segments.sql
Script: undo_users.sql
Script: wm_create_workspace.sql
Script: wm_disable_versioning.sql
Script: wm_enable_versioning.sql
Script: wm_freeze_workspace.sql
Script: wm_get_workspace.sql
Script: wm_goto_workspace.sql
Script: wm_merge_workspace.sql
Script: wm_refresh_workspace.sql
Script: wm_remove_workspace.sql
Script: wm_rollback_workspace.sql
Script: wm_workspaces.sql
Script: asm_alias.sql
Script: asm_clients.sql
Script: asm_diskgroups.sql
Script: asm_disks.sql
Script: asm_disks_perf.sql
Script: asm_drop_files.sql
Script: asm_files.sql
Script: asm_files_10g.sql
Script: asm_files2.sql
Script: asm_templates.sql
Script: asmm_components.sql
Script: awr_snapshots_dbtime_xls.sql
Script: example_create_clob_8.sql
Script: wm_unfreeze_workspace.sql

Oracle Database Error Messages

 

• Error Codes In Oracle between ORA-35500 – ORA-37000
• Oracle 10g Error Codes between ORA-25000 – ORA-26000
• Oracle Db Error Codes between ORA-24000 – ORA-24500
• List of All Oracle Error Codes between ORA-23000 – ORA-24000
• Oracle Db Error Codes between ORA-20000 – ORA-23000
• List of All Oracle Error Codes between ORA-17000 – ORA-20000
• Oracle Database Error Code List between ORA-16500 – ORA-17000
• Oracle Database Error Messages between ORA-15500 – ORA-16500
• Error Codes In Oracle between ORA-15000 – ORA-15500
• Oracle Db-Error Codes List between ORA-14500 – ORA-15000
• Oracle 10g Error Codes between ORA-14000 – ORA-14500
• Oracle Db Error Codes between ORA-13500 – ORA-14000
• Oracle Error Code Descriptions between ORA-33500 – ORA-35500
• Oracle Error Descriptions between ORA-32500 – ORA-33500
• Oracle Db-Error Codes List between ORA-31500 – ORA-32500
• Oracle 10g Error Codes between ORA-31000 – ORA-31500
• Oracle Db Error Codes between ORA-30500 – ORA-31000
• List of All Oracle Error Codes between ORA-30000 – ORA-30500
• Oracle Database Error Messages between ORA-29500 – ORA-30000
• Error Codes In Oracle between ORA-29000 – ORA-29500
• Oracle Error Code Descriptions between ORA-28000 – ORA-29000
• Oracle Error Descriptions between ORA-27000 – ORA-28000
• Oracle Db-Error Codes List between ORA-26000 – ORA-27000

 

 

 

Top Oracle Database Error Messages

 

• ora-13417 : null or invalid layerNumber parameter
• ora-26006 : Incorrect bind variable in column string's sql expression - string
• ora-01512 : error renaming log file string - new file string not found
• ora-02242 : no options specified for ALTER INDEX
• ora-24332 : invalid object type
• ora-06504 : PL/SQL: Return types of Result Set variables or query do not match
• ora-07842 : sllfcl: SYS$CLOSE failure
• ora-14617 : cannot add/drop values to DEFAULT subpartition
• ora-24777 : use of non-migratable database link not allowed
• ora-14073 : bootstrap table or cluster may not be truncated
• ora-38472 : VARCHAR representation of the data item is too long.
• ora-14168 : only one subpartition may be modified
• ora-28120 : driving context already exists
• ora-39220 : file name is too long
• ora-12639 : Authentication service negotiation failed

Oracle Database Error Messages

 

• Error Codes In Oracle between ORA-35500 – ORA-37000
• Oracle 10g Error Codes between ORA-25000 – ORA-26000
• Oracle Db Error Codes between ORA-24000 – ORA-24500
• List of All Oracle Error Codes between ORA-23000 – ORA-24000
• Oracle Db Error Codes between ORA-20000 – ORA-23000
• List of All Oracle Error Codes between ORA-17000 – ORA-20000
• Oracle Database Error Code List between ORA-16500 – ORA-17000
• Oracle Database Error Messages between ORA-15500 – ORA-16500
• Error Codes In Oracle between ORA-15000 – ORA-15500
• Oracle Db-Error Codes List between ORA-14500 – ORA-15000
• Oracle 10g Error Codes between ORA-14000 – ORA-14500
• Oracle Db Error Codes between ORA-13500 – ORA-14000
• Oracle Error Code Descriptions between ORA-33500 – ORA-35500
• Oracle Error Descriptions between ORA-32500 – ORA-33500
• Oracle Db-Error Codes List between ORA-31500 – ORA-32500
• Oracle 10g Error Codes between ORA-31000 – ORA-31500
• Oracle Db Error Codes between ORA-30500 – ORA-31000
• List of All Oracle Error Codes between ORA-30000 – ORA-30500
• Oracle Database Error Messages between ORA-29500 – ORA-30000
• Error Codes In Oracle between ORA-29000 – ORA-29500
• Oracle Error Code Descriptions between ORA-28000 – ORA-29000
• Oracle Error Descriptions between ORA-27000 – ORA-28000
• Oracle Db-Error Codes List between ORA-26000 – ORA-27000