Re: Import/Export problem

Chris Hamilton wrote:
>
> "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

Hi Chris,

you're completely right. Such thinks as described by the first author often happens when exporting a database with COMPRESS=Y. So ALWAYS think of making an export with rows and WITHOUT rows.

Greetings,

Hans Pfeiffer Received on Thu May 14 1998 - 00:00:00 CDT