Re: Exporting Oracle DB Question

Check the Oracle Servers Utilities Guide (documentation that comes electronically with Oracle) There are a whole series of parameters that can be set up within a PARfile to run with the export command. Make sure to run CatExp.sql also.This sets up the views needed to export and import.

On Thu, 30 Oct 1997 00:50:02 GMT, mike.burke_at_born.com (Michael R. Burke) wrote:

>I have a question on exporting Oracle database components from the
>DB's data dictionary.
>
>Specifically, I'm trying to find a way of exporting database
>componenets (tables, indexes, triggers, stored procedures, etc.) out
>of the data dictionary and into a file.  This file would essentially
>be one large script which would recreate these components.  One last
>requirement is that I do not want to export any of the data in the
>database.
>
>Oracle provides an "export" command which will export the database in
>one of three ways.  The following describe the method which is closest
>to statisfying my requirements:
>
>"Full mode - the full database is exported.  The entire data
>dictionary is read, and the DDL needed to re-create the full database
>is written to the export dump file.  This includes all tablespaces,
>all users, and all of the objects, data, and privileges in their
>schemas.  (Excerpted from "Oracle DBA Handbook", Kevin Loney).
>
>The problem is that this method also exports the data from the
>database.
> 
>Does anyone know of another way that I could accomplish this without
>exporting the data?
>
>Please respond via e-mail
>
>Thanks,
>- Michael Burke
>
Received on Thu Oct 30 1997 - 00:00:00 CST