Re: Editing dump file before Import??

"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.

Regards,

Sybrand Bakker, Oracle DBA Received on Tue Jul 11 2000 - 00:00:00 CDT