Oracle Operation

1.    Restore drop table(Note: trigger can’t berestored):

SELECT * FROM recyclebin where original_name='TABLE_NAME';

SELECT * FROM "BIN$NJu2pKUQLQHgU2YudAocrw==$0";

FLASHBACK table TABLE_NAME to before drop;

2.    Create trigger:

CREATE TRIGGER sft_test_trigger

   BEFORE INSERT OR UPDATEOF c1, c2 ON sft_test

   FOR EACH ROW

   WHEN (new.c1='cc1' andnew.c2='cc2')

   begin

  selectsft_test_sequence.NEXTVAL into :new.c3 from SYS.DUAL;

END sft_test_trigger;

 

3.    Get table definition

select DBMS_METADATA.GET_DDL('TABLE','TABLE_NAME')from DUAL;

select * from all_tab_cols where table_name ='TABLE_NAME';

4.    user lock process

b.     Login db sever by root user

c.      Execute bellow command(Please keep in mind that line profile_cloudapp should be typed as:
(dot)(space)(dot)profile_cloudapp):

su - oracle

bash

. .profile_cloudapp

d.     1) changeits password
2) unlock user
3) connect with this user

I.e.:

$  sqlplus "/assysdba"

SQL> alter user cloudappidentified by PASS_WD;

 

SQL> alter user USER_NAME accountunlock;

 

SQL> conn USER_NAME /PASS_WD

 

5.    Start db instance

connect / as sysdba
startup

6.    update batch_id

UPDATE TABLE_NAME COB SET batch_id=(

select distinct batch_idfrom TABLE_NAME_2 where

Adj_version=cob.Adj_version AND run_manager_version=COB.run_manager_version

AND effective_date=COB.effective_date

) where risk_stripe='SSS';