Re: Exporting Oracle DB Question

> Specifically, I'm trying to find a way of exporting database
> componenets (tables, indexes, triggers, stored procedures, etc.) out
> of the data dictionary and into a file.  This file would essentially
> be one large script which would recreate these components.  One last
> requirement is that I do not want to export any of the data in the
> database.

Mike,
For $50 I'll send you a PL/SQL package that reverse-engineers an entire schema. It generates syntactically correct DDL statements for existing: Tables
Constraints (primary key/unique key/foreign key/check) Secondary indexes (ones not related to constraints) Views
Sequences
Synonyms
Grants
You can also specify each type of object separately if you only want to r-e one type or one specific object.

You must compile it as SYS, then run it from SQL*Plus with set serveroutput on and spool to a file.

As a bonus I'll include a stored procedure that lets you see the index definition for any table in any schema (also compiled as SYS). Dan Clamage
1450 W. 116th Ave #25
Westminster CO 80234
Include your email address with your check or M.O. If you email me first requesting it, I'll email it to you, and if you like it, just mail me the check.
- djc Received on Thu Oct 30 1997 - 00:00:00 CST