Re: Editing dump file before Import??

"Sybrand Bakker" <postbus_at_sybrandb.demon.nl> writes:

> "Robert Wagner" <RobertWagner_at_alum.mit.edu> wrote in message
> news:ahMa5.17934$9E6.102645_at_newsr1.maine.rr.com...
> > I've been trying to edit the .DMP file created by an EXP80, in order to
> > change things like the tablespaces for tables and indexes. But when I try
 to
> > use the edited file in an import, I get "IMP-00038: Could not convert to
> > environment character set's handle."
> >
> > Is there a CRC check on the file, or something else which makes this kind
 of
> > operation impossible?
> >
> > Or could it just be a typo in making the changes?
> >
> > TIA >>>> Robert
> >
> >
> >
> >
> A dump file is *NOT* an ASCII file.
> You should *NEVER EVER!!* edit the dump file. If you want to change create
> tablespace statements, use the following procedure:
> run imp with the following parameters
> show=y full=y log=<anyfilename>
> In <anyfilename> you will find a dump of *all* commands including the create
> tablespace statements. You could easily edit that file, pull the statements
> out and change them.
> If you want to change tablespaces for tables, make sure
> the default tablespace of the destination user has been changed, the user
> doesn't have unlimited tablespace privilege, and has quota on the new
> tablespace only.
> For changing index tablespaces, run imp with the indexfile=<filename> and
> you will get all create index statements in that filename.
> Please do *NOT* start hacking a dmp file, it's not going to work, and it is
> not supported.
>

If you edit it in Emacs you can usually get away with changing the tablespace name, though you are doing it at your own risk and if you tell anyone that I said that I will have to kill you :7)

cheers

Phil

--
Philip W. Britton