Re: Scripting a database

kpkeller_at_linuxmail.org (KPK) wrote in message news:<6f5ea0d.0210091300.75cedd81_at_posting.google.com>...
> Hello:
>
> We currently use Oracle 8.1.7 in our office. I am somewhat new to
> Oracle and would like to know if there is a way (hopefully a wizard)
> that will allow me to script a database.
>
> I would like to be able to choose what to script.
>
> Example:
> All tables, indexes, Primary and Foreign keys and views but not
> sprocs.
> All tables, indexes, primary and foreign keys only, etc.
>
> It would be nice if there were a wizard within dba studio or something
> that would allow me to do this.
>
> Any help would be appreciated.
>
> Thanks!

Use google to search the archives as numerous scripts have been posted over the years. The imp indexfile=file_name parameter will create a file of database object source code.

The IOUG web site has several source generation scripts available though I believe that membership in the IOUG is necessary to download them.

Kevin Loney published a book of scripts, many of which are for object source generation.

HTH -- Mark D Powell -- Received on Thu Oct 10 2002 - 14:36:48 CEST