Dec 172017
A collection of various tools for an Oracle DBA.
File DBATOOLS.ZIP from The Programmer’s Corner in
Category Databases and related files
A collection of various tools for an Oracle DBA.
File Name File Size Zip Size Zip Type
BUILDEXI.COM 556 333 deflated
CONCAT.PC 2088 869 deflated
CONCAT.PFO 2625 858 deflated
CONCAT.PPA 3593 1228 deflated
CONCAT.PPL 2174 928 deflated
CRT.RPT 14202 3445 deflated
DBATOOLS.TXT 6339 2184 deflated
DCLC.COM 276 168 deflated
DCLC.PC 1572 750 deflated
DCLCOB.COM 316 183 deflated
DCLCOB.PCO 3419 953 deflated
DCLFOR.COM 311 182 deflated
DCLFOR.PFO 1973 785 deflated
DCLGEN.C 44340 9558 deflated
DCLGEN.COM 396 208 deflated
DCLGEN.PC 21876 6384 deflated
DCLGEN.SQL 612 204 deflated
DDL.SQL 2279 833 deflated
DELFORM.SQL 1708 396 deflated
DESCRIBE.RPT 3829 1087 deflated
DESCRIPT.COM 216 140 deflated
DESCRIPT.PC 13495 4384 deflated
DROP_ALL.SQL 621 279 deflated
DSQL.C 30451 7663 deflated
DSQL.COM 337 225 deflated
DSQL.PC 16113 5194 deflated
DYNAMIC.PC 4811 1485 deflated
EMP.C 197 117 deflated
EMP.COB 480 155 deflated
EMP.FOR 253 126 deflated
EXECSQL.COM 582 286 deflated
EXECSQL.PC 12441 3994 deflated
EXITTEST.FRM 1535 524 deflated
EXITTEST.INP 5571 890 deflated
EXITTEST.MAR 249 142 deflated
EXITTEST.OBJ 323 212 deflated
FORM.RPT 22355 4705 deflated
LABEL.RPT 4422 906 deflated
LIAP.COM 528 289 deflated
OCI_W_PC.COM 520 301 deflated
OCI_W_PC.PC 7277 2426 deflated
ORASTD.H 19429 5765 deflated
PARTSIZE.SQL 575 265 deflated
PCCNET.PC 5141 1805 deflated
PREPCOB.COM 154 102 deflated
PREPCOB.PCO 11064 2524 deflated
PTR_VRCH.COM 267 158 deflated
PTR_VRCH.PC 1615 802 deflated
SCHEDULE.INP 36589 3112 deflated
STOP_ORA.COM 2468 1149 deflated
TABSPACE.SQL 2413 1005 deflated
TRIGGER.RPT 3280 1120 deflated

Download File DBATOOLS.ZIP Here

Contents of the DBATOOLS.TXT file


******************************* DBA TOOLS ********************************

CRT.RPT A SQL*Report application.
It requests a CRT device name and produces a listing
of all attributes for that device saved within the
Type out the file itself for details on use.

DDL.SQL Command file which generates the CREATE TABLE
command for a given table.

TABSPACE.SQL A query that can be used to determine the usage of
space by data within a table.

PARTSIZE.SQL A query that will recap the available space within
each partition of a database.

DELFORM.SQL Deletes all form applications saved in the database
for a given user account. This might be helpful to
complete the cleanup of objects owned by an account
which is to be removed.

DESCRIBE.RPT A SQL*Report program that documents all tables
accessable by a given account in a form similar to
SQL*Plus DESCRIBE. Includes view text for views.

DROP_ALL_TABLES.SQL When executed from within SQL*Plus, it will drop
all tables owned by the user running the procedure.

STOP_ORAUSER.COM A VMS command file that stops VMS processes that are
using Oracle. This might be helpful to insure that
all users are off Oracle prior to IOR SHUT and system

********************* PRO*Oracle EXAMPLES AND TOOLS ************************

Most for these programs have associated .COM files that will precompile,
compile, link, run and provide data to facilitate the use or understanding
of the routine.

DCLGEN.PC A C program that generates a file which can be
INCLUDE'd in a host language routine to declare
variables necessary to interface to a specific
table in the Oracle database. The function requires
1) the language to be used 2) the username and password
to access Oracle and 3) the table name.
More documentation is included withing the file.
There are example programs that show the use of the
generated files. They are:


PREPCOB.PCO Illustrates dynamic SQL using the PCC PREPARE stmt.
'Includes' a file (EMP.COB) which has been created with

DYNAMIC.PC Illustrates the use of dynamic SQL (PREPARE and EXECUTE)
to build a dynamic WHERE clause.

OCI_W_PCC.PC A C example that uses both the Precompiler interface
and the OCI interface together.

DSQL.PC A C example that uses dynamic SQL to process any query
entered by the user. Works much like SQL*Plus.
This uses descriptors, the most complicated but flexible
type of dynamic SQL.

DESCRIPTOR.PC Another C example, very similar to DSQL, but without
as many subroutines and with more comments.

PTR_VRCHR.PC A C example that uses pointers to VARCHAR datatypes as
bind variables in a SQL statement.

EXECSQL.PC A C routine that incorporates dynamic SQL to evaluate
a SQL statement passed as an argument.

PCCNET.PC Example of the use of the "AT" clause in various
embedded SQL statement to direct cursor operations to
remote databases using SQL*NET.

********************* [ SQL*Forms EXAMPLES AND TOOLS ] *********************

FORM.RPT A SQL*Report application.
It requests a SQL*Forms application name and produces
documentation for that application that includes all
triggers, attributes, comments, etc.
Type out the file itself for details on use.

TRIGGER.RPT Similar to FORM.RPT but only lists the trigger steps
for a given SQL*Forms application that is saved in the

CONCAT.PC Example of a user exit routine written in C to
be precompiled using Pro*C.
This is the type of generic user exit that any SQL*Forms
application might call to quickly concatenate multiple
field values into another field.

Other files related to building or using this exit are:

BUILDEXIT.COM - Steps to recompile and link the exit.
LIAP.COM - Modified link proc to link in the exit.
EXITTEST.INP - A SQL*Form application to test the exit.
EXITTEST.MAR - The output from GENXTB for the exit.
CONCAT.PC - The source for the user exit in C.
CONCAT.PFO - The source in FORTRAN.
CONCAT.PPA - The source in PASCAL.
CONCAT.PPL - The source in PL1.

SCHEDULE.INP Example SQL*Forms application displays a monthly
calendar and allows user to schedule events for selected
days. It illustrates the use of KEY triggers, working
with TIME information. Comments are used to explain
some design considerations.

SCHEDULE.EXP - A table export of two tables (EVENT,
CALENDAR) necessary to use SCHEDULE.

******************** [ SQL*Report EXAMPLES AND TOOLS ] ********************

LABEL.RPT A SQL*Report application to produce 3 across mailing
labels from a generic address table. The table
structure is described within the file.

 December 17, 2017  Add comments

 Leave a Reply

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <s> <strike> <strong>