Let's suppose you have a 11.2.0.X Oracle database and you want to import it ( entire or only some schemas ) into a 11.1.0.7 database or 10.2.0.X database
Solution : export from the beginning , with a compatible parameter :
expdp version=10.2
or
expdp version=11.1
After that, take the dump, move it to an oracle datapump directory on the destination server and start the import
Get Oracle Partition High Values as VARCHAR2 types instead of LONG in
Oracle 19c and earlier
-
Here’s a little PL/SQL function create_partition_high_value_func.sql that
allows you to write SQL queries against data dictionary for partition
maintenan...
Acum 4 ore
Niciun comentariu:
Trimiteți un comentariu