Re: Backup database

If you are running Oracle 9i you can also try the new

dbms_metadata Package

But I agree exp rows = n is the old standby.

Stephen C. Ashmore
Brainbench MVP for Oracle Administration http://www.brainbench.com

Author of: 'So You Want to be an Oracle DBA?'

"Sybrand Bakker" <postbus_at_sybrandb.demon.nl> wrote in message news:ued3e1tbao21b2_at_corp.supernews.com...
>
> "John M." <sas_at_sas> wrote in message
> news:oxuF8.45065$oG6.201368_at_news.chello.at...
> > Hi,
> >
> > how can I generate an sql script, which build my database with all table
> at
> > nay time without data. I want to save my database structure from the
> > existing database.
> >
> > Sorry, but I didn't find a better place to ask this. Is there any sql
> > newsgroup for newbies?
> >
> > Thanks!
> > John.
> >
> >
>
> Oracle has export for this purpose. You can use export with ROWS=N, and it
> will dump all object definitions.
>
> There is no newsgroup for newbies.
> Questions with respect to everything that comes with the Server software
> belongs to the .server group, those pertinents to Designer/Developer in
> .tools, and questions with respect to third party products in .misc.
> Most people posting simply ignore this distinction and cross- and/or
> multipost all their messages in all three groups. Which just keeps the
> people responding busy, especially for multiposted messages as you don't
see
> the responses the question already got.
>
> Please also never assume we know your version and your platform.
>
> Regards
>
> --
> Sybrand Bakker
> Senior Oracle DBA
>
> to reply remove '-verwijderdit' from my e-mail address
>
>
>
>
>
Received on Sat May 18 2002 - 15:35:21 CDT