Skip to Main Content

Oracle Database Express Edition (XE)

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

Are TSTZ (time zone file) updates available for XE?

user-iqv1zFeb 13 2023

We are using XE 21c to import data using data pump exported from what I think is 19c. (It is delivered as an automated production process from a partner organization, so we don't have much control over it; we were all previously using version 12 with no problem.) However, the 19c installation apparently has a newer time zone definition file than XE 21c, so we get when running impdp:

===
Connected to: Oracle Database 21c Express Edition Release 21.0.0.0.0 - Production

ORA-39002: invalid operation

ORA-39405: Oracle Data Pump does not support importing from a source database with TSTZ version 36 into a target database with TSTZ version 35.

===

Everything I can find says that patches are not available for XE. What I can't figure out is whether an update to the TSTZ version is considered a patch--or where to find it.

Or, do we need to move to EE (enterprise edition) in order to keep up with the definition of DST in Volgograd (that was the change from TSTZ 35 to 36!)?

Thanks,
Dan

Comments
Post Details
Added on Feb 13 2023
1 comment
1,583 views