Re: Export into SQL Script

"Michel Cadot" <micadot{at}altern{dot}org> schrieb im Newsbeitrag 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.

But doesn't this require import?
I think, he meant something which you could feed sqlplus.

Lots of Greetings!
Volker Received on Tue Jan 13 2004 - 10:50:37 CST