Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Exporting a Schema to a script files
On Mon, 19 Aug 2002 17:29:41 GMT, Daniel Morgan
<dmorgan_at_exesolutions.com> wrote:
>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.
Imagine it being the easiest way to disseminate object information to users with no immediate DB access.
> Sounds to me like a maintaince-version control nightmare.
Yes. But, the objects are not seem to be updated often. So, it may be cumbersome, but not a nightmare.
>If you can settle for a single file just about every product will do it.
>
>Daniel Morgan
Brian Received on Mon Aug 19 2002 - 13:01:28 CDT