FOR YOUR INFORMATION ESIS and EPFAL are now part of Logica. The Internet email addresses of the staff has changed to the following - [EMAIL PROTECTED] eg [EMAIL PROTECTED] 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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
