| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> ORA-1874 time zone hour must be between -12 and 13
FOR YOUR INFORMATION ESIS and EPFAL are now part of Logica. The Internet email addresses of the staff has changed to the following - lastnameinitial_at_logica.com eg SMITHK_at_logica.com. Emails using the old format will continue to be delivered until 30th June 2001.
I posted a message on the list several weeks ago regarding the following failure. I also logged it with Oracle on Metalink. Despite several suggestions I was never able to resolve the issue. Someone else posted a new message about it last week and there was not much response to that one either.
IMP-00003: ORACLE error 1874 encountered ORA-01874: time zone hour must be between -12 and 13 IMP-00000: Import terminated unsuccessfully
I have just managed a workround. Moving an export file from one local server to another produced the problem. As previously the export had been made on a client server I had never had chance to get to their system to try anything. This time with it being a local server I managed to track down and resolve the problem, at least in one environment.
The unix environment variable was set to TZ=GMT0BST,M3.5.0,M10.5.0. I removed this (export TZ="") and performed the export and the import on the target server (where the variable was not set) worked fine. Previously with only having access to the target server I had never had the opportunity to change any variables on the export server.
I had tried every permutation known to man on the import server all without success so as far as I can see the only answer is to ensure that the source export has the correct (or null ) TZ variable setting that will match with the target import server
Hope that is useful
John
This e-mail and any files transmitted with it, are confidential to Logica and are
intended solely for the use of the individual or entity to whom they are addressed.
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Hallas, John
INET: HallasJ_at_logicae.com
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists --------------------------------------------------------------------To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Received on Tue May 29 2001 - 10:11:27 CDT
 |
 |