When you enable direct IO for an oracle database ( filesystemio_options = directio or filesystemio_options = setall ) , you may encounter this error in alert.log , when opening the database .
Cannot re-create tempfile the same name file exists
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 zile
Niciun comentariu:
Trimiteți un comentariu