Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: Exporting a Schema to a script files

Re: Exporting a Schema to a script files

From: Daniel Morgan <dmorgan_at_exesolutions.com>
Date: Mon, 19 Aug 2002 17:29:41 GMT
Message-ID: <3D612AF9.3FBBBF2@exesolutions.com>


Brian Tkatch wrote:

> We are looking for a way to export the schema of a user to a bunch of
> text files. That is, one file per object (and its priveledges,
> indexes, etc...) with a master file calling them in the correct order.
> I saw the exp tool, but it doesn't seem to have a SQL statement
> export.
>
> Is there a script or a tool that does this? Curently, I am trying to
> do an export from a tool (PL/SQL Developer) and I am waiting for it to
> finish. When it does, I guess I will have to make order from the
> hundreds of files.
>
> Brian

I can't think of any tool that does what you want because I can't in my wildest nightmares understand why anyone would want separate files for each object. Sounds to me like a maintaince-version control nightmare.

If you can settle for a single file just about every product will do it.

Daniel Morgan Received on Mon Aug 19 2002 - 12:29:41 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US