you can use the SHOW=y(I believe that is the correct parameter) to get the
SQL. The SQL is not useful as a .sql script though.
"Michel Cadot" <micadot{at}altern{dot}org> wrote in message
news:4004211b$0$1169$636a55ce_at_news.free.fr...
>
> "Anton Güntsch" <a.guentsch_at_bgbm.org> a écrit dans le message de
> news:bu13dr$6q7$1_at_news.cs.tu-berlin.de...
> > Thanks Daniel! Now that I know that it is possible could someone please
tell
> > me how it is possible to export Oracle Database into SQL scripts,
please?
> > Best wishes
> > Anton
> >
> > "Daniel Morgan" <damorgan_at_x.washington.edu> wrote in message
> > news:1074006467.376256_at_yasure...
> > > Anton Güntsch wrote:
> > >
> > > > Hi,
> > > > with PostgreSQL it is possible to export an entire database (data,
> > > > structure, permissions, etc.) into an SQL script. The script can
then be
> > > > used to re-create the database just by running it on a different
> > database
> > > > server. Could you please tell me whether this is also possible for
> > Oracle
> > > > databases?
> > > >
> > > > Thanks
> > > > Anton
> > >
> > > Yes.
> > >
> > > --
> > > 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)
> > >
> >
> >
>
> Export utility: exp.
>
> Regards
> Michel Cadot
>
>
Received on Thu Jan 15 2004 - 13:01:37 CST
