RE: Problem with import

From: Hallas, John <HallasJ_at_logicae.com>
Date: Wed, 23 May 2001 10:41:02 -0700
Message-ID: <F001.0030BE24.20010523072713@fatcity.com>

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.

Randy

I have posted a message about this before with no success. I have had a Metalink call logged with Oracle and that has been of no use either. I have tried every permutation of TZ and NLS_LANG values all with no luck.

I have sent a partial export to Oracle but they cannot seem to get round the problem either. Unfortunately I cannot speak directly with the source of the export because I believe it is an environment setting on their Unix server that is causing the mismatch.

Oracle do not seem to be much help on this, I hope someone on the list can offer more than them

John

                -----Original Message-----
                From:   Randy Pace [mailto:rpace_at_kiva.com]
                Sent:   22 May 2001 21:06
                To:     Multiple recipients of list ORACLE-L
                Subject:        Problem with import

                I have a database 8.1.7 personal and had a client send me an
export . When I
                try the import I get the message

                ORA-01874: time zone hour must be between -12 and 13.

                I have never run across this before. What can I do to

resolve the issue?

                Thanks for you help.


                Randy Pace     Phone 801 495 9300
                9662 S 700 E       Fax 801 495 9301
                Sandy, Utah 84070    email rpace_at_kiva.com


                -- 
                Please see the official ORACLE-L FAQ: http://www.orafaq.com
                -- 
                Author: Randy Pace
                  INET: rpace_at_kiva.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).

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 Wed May 23 2001 - 12:41:02 CDT