The main problem : you want to use datapump ( expdp/impdp ) in order to move data between databases ( from 11G to 10G ).
In the default mode, this is not possible ( an 11G dump will not be recognized to a 10G database )
Solution: expdp directory=... schemas=.... version=10.2 ( this command should be performed on 11G database)
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 2 săptămâni
Niciun comentariu:
Trimiteți un comentariu