Oracle Delete Duplicate Row

1.Oracle Delete Duplicate Row In Oracle, we can delete duplicate rows by a criteria/condition: DELETE FROM T_TB1 WHERE rowid not in (SELECT MIN(rowid) FROM T_TB1 GROUP BY C_C1, C_C2, C_C3); ***C_C1, C_C2, C_C3: list of columns that form a criteria/condition

Oracle Create a Database Link

1.Create a Database Link -The database link is used to link two database together   CREATE DATABASE LINK OldToNew CONNECT TO fel IDENTIFIED BY fel USING ‘//192.168.1.128:1521/FEL’; COMMIT;   -The user account and the URL are the one of the destination DB that we want… Read More

Oracle Change Charset to UTF-8

1.Change Charset to UTF-8 conn as sysdba SHUTDOWN IMMEDIATE; STARTUP MOUNT; ALTER SYSTEM ENABLE RESTRICTED SESSION; ALTER SYSTEM SET JOB_QUEUE_PROCESSES=0; ALTER SYSTEM SET AQ_TM_PROCESSES=0; ALTER DATABASE OPEN; ALTER DATABASE CHARACTER SET INTERNAL_USE AL32UTF8; SHUTDOWN IMMEDIATE; STARTUP;

Oracle Kill Inactive Session

1.Command to Kill Inactive Session SELECT * FROM v$session WHERE status =’INACTIVE’;   select ‘alter system kill session ”’ ||sid|| ‘,’ ||serial#|| ”’ immediate;’ as insess from v$session where status=’INACTIVE’; commit;   select ‘alter system kill session ”’ ||sid|| ‘,’ ||serial#|| ”’ immediate;’ from v$session… Read More