Re: Exporting Oracle DB Question

Use ROWS=N parameter on full Export.

On Import, use the INDEXFILE=file_name, or use the SHOW=Y and LOG=file_name options. You could use the ROWS=N option on Import, too. Note that in the case of the file generated with INDEXFILE option, the CREATE TABLE and CREATE CLUSTER statements are commented (REMed) out. Also, from Version 7.1 and up, the commented CREATE TABLE statements in the INDEXFILE do not contain PRIMARY KEY or UNIQUE clauses. In both Import alternatives above, no actual import is performed; only the SQL statements to generate the database objects are written into the file you specify, so the ROWS=N are not really needed (but speed up things on Export). Edit the file to your heart's content and run it against your database.

Another option will be to run a full Export with ROWS=N and then a real Import (with ROWS=N or Y; it doesn' matter, since no data was exported). This will also create the database objects minus the data.

Hope this helps (and I haven't confused you too much !).

Michael Serbanescu

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 Fri Oct 31 1997 - 00:00:00 CST