Usually this error appears when you try to export/import with datapump from command line in bash/ksh , and your command has ( or ) inside .
example: expdp directory=export__directory dumpfile=expdp_dumpfiles_%U.dmp schemas=(...,....,....) COMPRESSION=ALL parallel=4
Solution : use escape characters \( or \)
example: expdp directory=export__directory dumpfile=expdp_dumpfiles_%U.dmp schemas=\(...,....,....\) COMPRESSION=ALL parallel=4
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 6 ore
Niciun comentariu:
Trimiteți un comentariu