Re: How to generate the script ?

"m" <orange.maori_at_caramail.com> wrote in message news:<caoush$2etq$1_at_biggoron.nerim.net>...
> Ok, It is not really easy for me, but, i try !
>
> I create tables in a oracle database.
> I developped an application working with this database.
> Now, i want to install the application on my customer server, and i like to
> know if it is possible on my oracle to generate a script wich can create the
> schema of my tables on my customer oracle server.
>
> Is it comprehensive ?

Assuming you have Oracle support, metalink has scripts to do this, like http://metalink.oracle.com/metalink/plsql/showdoc?db=NOT&id=90449.1 .

But you may just want to use the exp/imp utility. The instructions are in the Utilities Manual. Use COMPRESS=N.

Since your customer's setup is probably different than yours, you probably want to create the schema and tables in a script before imp, and just use imp to import seed data. But it all depends on how you wrote your app.

These are the sorts of things a DBA could show you how to do.

>
> Many thnaks in advance.
>
>
> "Daniel Morgan" <damorgan_at_x.washington.edu> a écrit dans le message de
> news:1087306607.519773_at_yasure...
> > m wrote:
> >
> > > How can i do to create a script to generate the database on other system
> > >
> > > "anacedent" <anacedent_at_hotmail.com> a écrit dans le message de
> > > news:zCsyc.56759$tI2.36639_at_fed1read07...
> > >
> > >>m wrote:
> > >>
> > >>>Hi,
> > >>>
> > >>>I'm a beginner in Oracle 9i and i like to know if it is possible to
> > >
> > > generate
> > >
> > >>>the script of a database automaticaly.
> > >>
> > >>Yes, it is possible (assuming that you know what you are doing).
> >
> > Now that you have clarified your meaning ... you can not do this.
> >
> > Rather than trying to suggest a solution ... why don't you explain
> > the problem you are attempting to solve. We can then tell you how
> > to accomplish your goal.
> > --
> > Daniel Morgan
> > http://www.outreach.washington.edu/ext/certificates/oad/oad_crs.asp
> > http://www.outreach.washington.edu/ext/certificates/aoa/aoa_crs.asp
> > damorgan_at_x.washington.edu
> > (replace 'x' with a 'u' to reply)
> >

jg

--
@home.com is bogus.
http://www.signonsandiego.com/uniontrib/20040616/news_1b16gateway.html