Timezone error importing dump from Oracle 10g

Asked

Viewed 373 times

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

1 answer

1

There is a thread in the Oracle community about this problem.

After reading it, I would try to set the following in your AddVMOption -Duser.timezone=CET:

AddVMOption -Duser.timezone=CET

Or else some Timezone from your site.

From what I understand, this arrow the Timezone of your JVM.

I also don’t know the consequences of this, but preferably try using the same Timezone previously configured. If it works, it is worth checking if it worked the right date even, overall.

  • the problem is that this thread concerns the manager Enterprise, not the imp tool.

  • 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?

  • The problem I’m conducting an emergency reactor

Browser other questions tagged

You are not signed in. Login or sign up in order to post.