Oracle Database

Hello administrator, this is a promising new site to bring to the Oracle world - good luck!

--======================================================
--
-- Title: viewts.sql
-- Description: To display all database tablespaces and their
--associated datafiles and sizes. 8i, 9i, 10g
--
-- Usage/Notes :
--
-- Author: Fred Bloggs
-- Date: 08 April 2008
--
-- Version: 1.00
--
-- Amendment:
-- History
--
--======================================================

#!/bin/ksh -x
#######################################################################
#
#Script : myscript.ksh
#
#Date : 1st May 2008
#
#Author : Joe Bloggs
#
#Description : Copies the alert.log to alert.20080501 and
#and empties the original files.
#
#Parameters : None.
#
# HistoryDateNameReason
#dd/mm/yyInitialsDescription of change
#
########################################################################

In order for this site to become a successful, free and reliable resource for all things Oracle Database, it is important to ensure all scripts function properly and do what they say on the tin! As such, any scripts submitted on these forums should follow these guidelines

GUIDELINES

1. Every script should be tested.

2. Scripts submitted should contain a script header. See the example script post for standard oracle-wiki header.

3. Preferably, documentation should be contained within the script header. Alternatively, if the documentation is particularly detailed or large, it should be uploaded to the site with the script or a link provided to an external source.

4. Where applicable, details of the database version, O/S version and O/S name that the script runs against should be present in the script header.

5. A brief description of what the script does should also be in the script header. See the example script post.

Where possible, admins will test the script before it is submitted to the scripts section. (Subject to platform and major version availability and admin resources)

AND FINALLY

It should go without saying,

• NEVER run any script in production systems before testing on YOUR own test environment.

• ALWAYS read the documentation provided with the scripts

• AT LEAST try to understand what it is your running before running it. DONT RUN THE SCRIPTS BLIND.

• Oracle-Wiki STRONGLY recommends you only run the scripts in our script area. If a script appears here, but not in our script area, it could mean one of two things:-

i) We haven't reviewed it to see if it meets our standards.

OR

ii) We have reviewed it and concluded it is not up to our standards or is unsafe to run.

Its your choice. In the infamous words of Dirty Harry "Do you feel lucky? Well, do ya, punk?

DISCLAIMER

The nature of scripting is that bugs will be present in all but the most basic scripts. Therefore, no guarantee, warrantee or endorsement is given to any of the scripts on this site. The use of these scripts is done so entirely at the discretion and risk of the person running them.