Re: Script To scan/rebuild tables needed...

Randy:

I have already done this type of thing. I have an application called DATADICT that includes scripts for just this sort of thing. Most of the stuff works with v6 or ORACLE7.

The program, d_tabddl.sql, extracts a table definition from the data dictionary, including storage parameters, column types and lengths, defaults, constraints, and indexes. You would need to disable some queries to run on v6.

Also included are scripts to extract triggers, procedures, indexes, views, sequences, etc., and lots of other goodies.

Call me at (301) 548-2613 for more details. If you want to download the application and check it out, you can anonymous ftp it from ftp.sratech.com, in the /pub/oracle directory. The file is called datadict.zip. It is a PKZip v2 file, with all the scripts and source code, and some instructions.

Or, I can e-mail it or surface mail it.

Chris Hamilton
SRA Technologies, Inc. Received on Mon Jul 17 1995 - 00:00:00 CEST