Re: Generating a SQL script of a database

In article <nyL35.594$oW3.60574_at_news.flash.net>,   "Rob George" <rgeorge_at_usa.net> wrote:
> Hi All
> Is there an easy way to generate a script of a database/scheema? (
 that can
> be edited)
>
> Thanks Rob George
>
>

Yes. It involves the exp and imp utilities. First, export the database or schema using exp:

exp <user/password> file=<user>.dmp owner=<user>

This will export the given users schema. Now use imp to generate the text file:

imp <user/password> file=<user>.dmp full=y show=y > <user>.sql

This will generate an editable script for you.

--
David Fitzjarrell
Oracle Certified DBA


Sent via Deja.com http://www.deja.com/
Before you buy.