A tester mais ça a l'air fou !!!
-
-
Flashback database
3 manières de faire :
SQL> flashback database to TIMESTAMP(sysdate - 2/24); --> flash back to 2 hr
SQL> FLASHBACK DATABASE TO TIMESTAMP SYSDATE-(1/24/12); --> Flashback 5 minutes.
SQL> flashback database to timestamp to_date('27-JUN-2016 19:50:00','DD-MON-YYYY HH24:MI:SS'); --> flash bakc to a specific time periodsource : https://www.c-sharpcorner.com/article/flashback-database-in-oracle2/
-
Corruption de données - ORA-26040: Data block was loaded using the NOLOGGING option
https://chenguangblog.wordpress.com/2011/02/11/ora-26040-data-block-was-loaded-using-the-nologging-option/
et pour trouver l'objet du bloc corrompu :
SELECT segment_type, segment_name
FROM dba_extents
WHERE file_id = <numero du datafile>
AND block_id < <numero du bloc>
AND block_id + blocks >= <numero du bloc>; -
Datapump , export query avec date
http://amit7oracledba.blogspot.com/2013/12/query-parameter-in-datapump-utility.html
-
Table partitionnement
https://www.oracle-dba-online.com/sql/oracle_table_partition.htm
-
Déterminer la taille d'un LOB
https://nguyentichthanh.wordpress.com/how-to-determine-the-actual-size-of-the-lob-segments-and-how-to-free-the-deletedunused-space-abovebelow-the-hwm-doc-id-386341-1/