Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> imp 00038 when modifying exp file and running imp
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
![]() |
![]() |