ORA-39353 Data was not imported for Cannot locate the time zone version file

ORA-39353 Data was not imported cannot locate the time zone version file.

Error occurred when i tried to impdp the dump file from oracle 12c version to 11.2.0.4 version database.Its occurred due to missing the timezone file

Used Expdp backup for the database with version clause from the 12c database

expdp version=11.2 directory-dump dumpfile=data.dmp logfile=data.log

Note:when i tried to import in 11.2.0.4 version,its failed with following error

ORA-39353 Data was not imported for Cannot locate the time zone version file.

Resolved: copy timezlrg_18.dat from 12c dbhome to 11g dbhome.

1. On Oracle 12c home:go to location %ORACLE_HOME\oracore\zoneinfo
2.copy the timezlrg_18.dat file
3. paste at 11g dbhome %oracle_home%\oracore\zoneinfo folder

Note: It is temporary fix, you need to upgrade timezone.

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.