Oracle Hata Kodları

ORA-39358: Export Dump File Version Not Compatible

ERROR :
While importing dump file, got error as

ORA-39358: Export dump file version 12.2.0.1.0 not compatible with target version 11.2.0.4.0 .

SOLUTION:

Firstly check the compatible parameter of both source and target database.

Source DB 
SQL> show parameter compatible
NAME TYPE VALUE
------------------------------------ ----------- ----------------------------
compatible string 12.2.0.1.0
noncdb_compatible boolean FALSE
 
TARGET DB

SQL> show parameter compatible
 
NAME                                 TYPE        VALUE
------------------------------------ ----------- -----------------------------
compatible                           string      11.2.0.4.0

We can see the source compatible parameter is higher version(12.2.0.1) and target is lower(11.2.0.4). A dump file generated from database with higher compatible parameter can’t be imported to a database with lower compatible value. Either both should be same or target db compatible can be higher than the source compatible.

To fix it, While taking export use VERSION=11.2 parameter .

$ expdp dumpfile=ABUZER.dmp logfile=ABUZER.log directory=EXPDIR full=y version=11.2
Etiketler

Notice: Trying to access array offset on value of type bool in /home/wwwbugra/public_html/wp-content/themes/jannah/framework/classes/class-tielabs-filters.php on line 340

Notice: Trying to access array offset on value of type bool in /home/wwwbugra/public_html/wp-content/themes/jannah/framework/classes/class-tielabs-filters.php on line 340

Notice: Trying to access array offset on value of type bool in /home/wwwbugra/public_html/wp-content/themes/jannah/framework/functions/media-functions.php on line 114

Notice: Trying to access array offset on value of type bool in /home/wwwbugra/public_html/wp-content/themes/jannah/framework/classes/class-tielabs-filters.php on line 340

Notice: Trying to access array offset on value of type bool in /home/wwwbugra/public_html/wp-content/themes/jannah/framework/functions/media-functions.php on line 114

bparlayan

Blog sitemi boş zamanlarımda hem biraz karalamak hemde mesleki tecrübeleri paylaşmak için kullanmaktayım. Burası benim deşarj noktam. Bu paylaşımları istediğiniz gibi çoğaltabilir ve kullanabilirsiniz : ). Ufak bir teşekkür yeterli. bugra[@]bugraparlayan.com.tr adresinden iletişim kurabilirsiniz.

İlgili Makaleler

Bir yanıt yazın


Notice: Trying to access array offset on value of type bool in /home/wwwbugra/public_html/wp-content/themes/jannah/framework/classes/class-tielabs-filters.php on line 340

Notice: Trying to access array offset on value of type bool in /home/wwwbugra/public_html/wp-content/themes/jannah/framework/functions/media-functions.php on line 114

Notice: Trying to access array offset on value of type bool in /home/wwwbugra/public_html/wp-content/themes/jannah/framework/classes/class-tielabs-filters.php on line 340

Notice: Trying to access array offset on value of type bool in /home/wwwbugra/public_html/wp-content/themes/jannah/framework/functions/media-functions.php on line 114
Başa dön tuşu
Kapalı