Re: Question: Schema Extract... How To?

Hi Mike,

	You can do this using exp and imp.  (Sorry I don't have
	docs handy and can't tell you the syntax.)  From what I
	recall it isn't obvious and you will have to read the
	fine manual. :-(  

	I have used this technique to get a script I could edit
	in order to relocate the tables and indexes in a moderate
	size database (150 tables, 5GB of data, 7,000,000 rows in
	the largest table).  The content is all there, but the
	editing was tedious.  I later used the same script when
	I upgraded from 7.2.x to 7.3.2.

Hope this is of value to you

Jerry

mike wrote:
>
> What is the easiest way to extract DDL for tables, indicies, etc other
> than using Entreprise Mgr. or another third party tool?
>
> Thanks,
>
> Mike
> email direct to mike_at_flipag.net
 

-- 
Jerry Gitomer        Computers and cameras
jgitomer_at_p3.net      One for the money, one for the fun
610/277-8643