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 -> imp 00038 when modifying exp file and running imp

imp 00038 when modifying exp file and running imp

From: Viewer <bmotzer_at_spacestar.com>
Date: Sun, 11 Apr 1999 11:52:11 -0500
Message-ID: <7eqk44$iid$1@news3.spacestar.net>


Fellow DBA's,

I know this isn't supported by Oracle (what fun things are?) but I want to modify an export file
and then run it through imp. On the export I tell it I only want the DDL, grants etc, not the actual data.
I then edit the file and even if I change just one letter and save it I get the following when I try
to imp.

Import file: ./expdat.dmp >
Enter insert buffer size (minimum is 4096) 30720>

IMP-00038: Could not find environment character set handle
IMP-00021: operating system error - error code (dec 2, hex 0x2)
IMP-00000: Import terminated unsuccessfully

My question is how does Oracle know I've changed the file? How can I get around this? What I'm trying
to do here is to revoke selects on objects going through import. I know that I could do the password
switcharoo and do it this way but in a 7*24 database the users aren't to happy with having their
passwords changed in the middle of the day.

Thanks Received on Sun Apr 11 1999 - 11:52:11 CDT

Original text of this message

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