Timezone error when importing dump of Oracle 10g

Navigation
0

My database server has failed and I need to restore a dump from a database. But when I try to run the tool imp from Oracle 10g x and it returns me the error 

1882 - região de fuso horário  não encontrada

Follow the log of the tool imp

  

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 made in character sets WE8MSWIN1252 and NCHAR   AL16UTF16 The export client uses the character set   US7ASCII (possible charset conversion)

     

IMP-00058: Oracle error: 1882 found ORA-01882: spindle region   time not found ORA-06512: under "SYS.DBMS_EXPORT_EXTENSION",   line 765 ORA-06512: in line 1 IMP-00009: abnormal end of file   Export IMP-00000: Import terminated successfully

The command you ran was: 

imp  file=C:\dumps15-06-27_biblioteca.dmp fromuser=BIBLIOTECA touser=BIBLIOTECA  buffer=1000000 commit=y Destroy=y ignore=y show=y skip_unusable_indexes=y

Thanks to everyone

    
asked by anonymous 02.07.2015 / 00:07

1 answer

1

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

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

AddVMOption -Duser.timezone=CET

Or some timezone of your location.

As I understand it, this sets the timezone of your JVM.

I also do not know the consequences of this, but prefer to try using the same timezone as before. If it works, it's worth checking if the correct date worked, overall.

    
02.07.2015 / 00:29
Error connecting to MySQL database in Java Mobile Cordova Geolocation