Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Exporting a Schema to a script files
Hi Brian
On Mon, 19 Aug 2002 13:24:08 -0400, Brian Tkatch <SPAMBLOCK_brian.tkatch_at_shopsforme.com_SPAMBLOCK> 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.
The freeware DBATool does exactly this. It can write all objects of a same type to one file, individual files or collect DDL like grants and synonyms into one file and big DDL like packages in separate files.
The DBATool will also autmatically generate the master scripts which create the objects in the correct order (tables before indexes etc) and the placement of the spooling commands.
The DBATool also contains a useful DDL 2 HTML converter for documentation purposes.
DBATool: http://www.DataBee.com/dt_home.htm
Cheers
Dale