Pages

▼
Thursday, April 20, 2023

Golden Gate 101

›
DBLOGIN DBLOGIN USER XXX, PASSWORD YYY Remove + Install DataPump STOP EXTRACT DPM_I_01 DELETE EXTRACT DPM_I_01 ADD EXTRACT DPM_I_01 EXTTRAIL...

Oracle COMMIT options from 11gR2

›
COMMIT_LOGGING and  COMMIT_WAIT Since Oracle 11gR2 new options to COMMIT were added: =================== COMMIT_LOGGING =================== ...
Monday, April 3, 2023

TRUNCATE PARTITION by example

›
Example to Truncate a partition with indexes. When doing Truncate to a partition, must do it with  UPDATE GLOBAL INDEXES; Code example: SQL...
Thursday, March 2, 2023

Oracle Support Levels and Oracle Supported Versions

›
Oracle has Three Support Levels Oracle Extended Support Provides comprehensive maintenance and software upgrades for five years from the gen...
Thursday, February 9, 2023

Convert LONG to VARCHAR2 in Oracle

›
Example of using Function co convert LONG to VARCHAR2 CREATE OR REPLACE FUNCTION LONG_2_VARCHAR     (p_table_name IN VARCHAR2,     p_partiti...
Monday, January 30, 2023

expdp error "ORA-39021: Database compatibility version 19.xx.0.0.0 is not supported."

›
============= Issue ============= Error during expdp version 19.x Connected to: Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - ...
Wednesday, January 18, 2023

How to copy stats from existing partition to a new partition

›
How to copy stats from existing partition to a new partition --Copy Start from Old Partition to New partition BEGIN  DBMS_STATS.COPY_TABLE_S...