| ORA-01874: time zone hour must be between -12 and 13 [message #53671] |
Fri, 04 October 2002 01:30  |
kris
Messages: 43
Registered: February 2002
|
Member |
|
|
Hi,
I was importing a dump file into an Oracle 8i 8.1.7 db. The dump file was also generated by Oracle 8i 8.1.7. The following error is being displayed. ORA-01874: time zone hour must be between -12 and 13.
The export seems to have been done using WE8ISO8859P1 character set while the import server is using US7ASCII. But I have heard that WE8ISO8859P1 is a super set of US7ASCII, so this should not be the problem or is it?
Neeways, if somebody knows about this, do lemme know. You will be doing me a favor.
Thanks,
Kris
|
|
|
|
| Re: ORA-01874: time zone hour must be between -12 and 13 [message #53674 is a reply to message #53671] |
Fri, 04 October 2002 11:13  |
Grant
Messages: 578
Registered: January 2002
|
Senior Member |
|
|
This is a tough one. You should do a search in MetaLink on this one but here are a few things you can look at.
1. Make sure you have NLS_LANG set the same on both servers. If you exported in WE then import with WE. Import will convert for you.
2. Make sure your timezone is set correctly or even try setting it to the source timezone then set it back when done.
3. If using DIRECT on export try CONVENTIONAL.
4. Call support :^)
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
