Re: sql script to recreate all database objects

On Mon, 28 Sep 1998 13:28:34 +1000, shayne nee-salvador <shaynen_at_somerset.com.au> wrote:
>How do you get Oracle to produce a script to create all the objects in
>the database?
>

One way is to use the exp program with full=y and rows=N, then the imp program with show=Y, redirect the output.

I habitually do an exp in development or new-to-me environments, then grep for whatever I need (often empirically determined sizing for tables or indices).

jg

-- 
These opinions are my own and not necessarily those of Information Quest or 
Pebble In The Sky http://www.informationquest.com mailto:jgarry_at_nospameiq.com
http://ourworld.compuserve.com/homepages/joel_garry   Remove nospam to reply.  
mailto:joel_garry_at_compuserve.nospam.com  "See your DBA?"  I AM the @#%*& DBA!