Re: Exporting structure

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

Steve <robertoc_at_fyiowa.infi.net> wrote in article <345766CD.645F_at_fyiowa.infi.net>...
> We need to export a user's schema, structure only, make sizing changes
> then import this in another instance. I know that the file in which
> export puts out is a binary file and you're not suppose to edit it.
> Is there a problem if I take what it exports modify it and clean it up
> and then instead of using import just execute it as a SQL script or is
> this a bad idea?
> Will I be missing any constraints/indexes etc?
> I talked with someone during Oracle Openworld in the Campground area and
> they said that there was an undocumented ascii export option. When I
> got back I called Oracle Support and they never heard of it.
Received on Wed Oct 29 1997 - 00:00:00 CST