0
My database server’s down and I need to restore a dump from a database. But when I try to run the Oracle imp tool 10g Xe it returns me the error
1882 - região de fuso horário não encontrada
Follow the imp tool log
Import: Release 10.2.0.1.0 - Production on Wed Jul 1 18:57:32 2015
Copyright (c) 1982, 2005, Oracle. All Rights reserved.
Connected to: Oracle Database 10g Express Edition Release 10.2.0.1.0 - Production
Export file created by EXPORT:V10.02.01 via direct path
import performed in the character sets WE8MSWIN1252 and NCHAR AL16UTF16 Export client uses character set US7ASCII (possible charset conversion)
IMP-00058: Oracle Error: 1882 Found ORA-01882: Zone Region time not found ORA-06512: in "SYS.DBMS_EXPORT_EXTENSION", line 765 ORA-06512: in line 1 IMP-00009: Abnormal file end export IMP-00000: Import successfully closed
The executed command was:
imp file=C:\dumps\2015-06-27_biblioteca.dmp fromuser=BIBLIOTECA touser=BIBLIOTECA buffer=1000000 commit=y Destroy=y ignore=y show=y skip_unusable_indexes=y
Thank you all
the problem is that this thread concerns the manager Enterprise, not the imp tool.
– João Luiz Grigoletti
By the documentation of imp, I did not find any parameter to set Timezone. Maybe at the time of saving the dump you have some option to include it in the file?
– falsarella
The problem I’m conducting an emergency reactor
– João Luiz Grigoletti