Re: OBJECT DEFINITIONS - REPOST

Nanda,
Go to Revealnet.com and download their Instant Scripts product .It has a lot of recreation scripts. Also TOAD ,EMBARCADERO etc tools can give you what you need viz all the scripts to recreate the objects. Also the Oracle Underground has some scripts on the same.

                Hope this helps.

                                        Tapan

Nandakumar wrote:
>
> In article <7q6vhk$5pn$1_at_nnrp1.deja.com>,
> Nandakumar <N.Kumar_at_rocketmail.com> wrote:
> >
> >
> > 1)
> > i have the definitions of some objects ( table, view, procedure,
> > function) in the data base. if i don't have the script that was used
> to
> > create these objects, is there an easy way to re-create the script
> from
> > the definitions available in the db.
> >
> > *** the following para was missing in the prev. post!
> > The re-created script should have all parts that it had when it was
> run
> > in the database. Say, the part of the script that creates a table,
> > should not only have the table structure but all the CONSTRAINTS
> > associated with the table.
> >
> > 2) when i select a LONG field, only a part of the value is displayed
> on
> > screen. how could i display the whole value??
> >
> > Thanks!
> > --
> > Nandakumar
> > (N.Kumar_at_rocketmail.com)
> >
> > Sent via Deja.com http://www.deja.com/
> > Share what you know. Learn what you don't.
> >
>
> --
> Nandakumar
> (N.Kumar_at_rocketmail.com)
>
> Sent via Deja.com http://www.deja.com/
> Share what you know. Learn what you don't.

Received on Tue Aug 31 1999 - 11:28:48 CDT