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

Home -> Community -> Usenet -> c.d.o.server -> Re: Import/Export problem

Re: Import/Export problem

From: Chris Hamilton <toneczar_at_erols.com>
Date: 1998/05/14
Message-ID: <6jfghc$7f1$1@goo.nwd.usace.army.mil>#1/1

"yaki_at_math.tau.ac.il;yacovw"@ecitele.com wrote:

>The question remains : is there any way i can edit the .dmp file?

Yes. But make a copy of it first!

You CAN edit the export file with an editor that handles binary stuff like Windows WordPad, but why take a chance. Plus if you have data in the file, that makes it very large and unwieldy to work with.

If you have a "skeleton" dump file (object definitions only, no data), work with that.

You can use the Unix or GNU "strings" command, passing it to "grep", to get all of the CREATE TABLE, ALTER TABLE, and CREATE INDEX statements, and redirect the output to a file. Then edit the file with a text editor and change what you wish. Each statement is on one long line. You can wrap them if you wish (makes reading and editing easier). Make sure you add a semicolon at the end of each statement so you can execute it in SQL*Plus.

A simple way of doing it is create the various tablespaces with reasonable default storage parameters, and omit the storage clauses in the CREATE statements entirely - just point them to the proper tablespaces.

Then fire up SQL*Plus and execute the script and it will pre-create all the tables and indexes.

Alternatively, you can do in import with the INDEXFILE=filename keyword and this will write a text file full of object creation statements. This can then be edited and executed in SQL*Plus.

Chris



Chris Hamilton -- toneczar_at_erols.com
City of Washington Pipe Band
http://www.serve.com/cowpb/chamilton.html Received on Thu May 14 1998 - 00:00:00 CDT

Original text of this message

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