error : TIMEZONE ora-01874
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 6 of 6

Thread: error : TIMEZONE ora-01874

  1. #1
    Join Date
    Sep 2001
    Posts
    24

    Angry

    While importing i am getting this error message
    ORA-01874 time zone should be between -12 and 13

    How do i do this?
    Shyla

  2. #2
    Join Date
    Feb 2001
    Location
    Paris, France
    Posts
    809
    1) what's your OS and version of Oracle ??
    2) did you FTP your dump file between a NT box and a Unix one ???

  3. #3
    Join Date
    Sep 2001
    Posts
    24

    ORA-01874

    Os version is windows 2000 professional

    Tried to import the .dmp file in nt and solaris but still the same error.
    Shyla

  4. #4
    Join Date
    Feb 2001
    Location
    Paris, France
    Posts
    809
    where was it exported from ?
    what is the value of the TZ env variable ?

  5. #5
    Join Date
    Sep 2001
    Posts
    24

    Angry

    The time zone variable is the one for UK [WE8ISO8859PI].
    But in my database it is US i,e USASCII.
    We just got the dump and while importing it says that

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

    So i created a database with UK char WE8ISO8859PI and tried to import , even then its of no use.

    REgards
    Shyla

    Shyla

  6. #6
    Join Date
    Jun 2001
    Location
    Helsinki. Finland
    Posts
    3,938
    Originally posted by shiala_100
    The time zone variable is the one for UK [WE8ISO8859PI].
    But in my database it is US i,e USASCII.
    We just got the dump and while importing it says that

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

    So i created a database with UK char WE8ISO8859PI and tried to import , even then its of no use.

    REgards
    Shyla

    I am afraid you will not be able to use your file. It is probably corrupted. The error you got might be missleading, i.e., not a Time Zone error. You usualy get this error if you transfer the .DMP file in ASCII format.


Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width