Re: Import/Export problem
Date: 1998/05/14
Message-ID: <6jfghc$7f1$1_at_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 CEST