Media recovery with NOLOGGING tables Posted on March 15, 2013, updated on November 23, 2015 by Yannick JaquierTable of contents Preamble Nologging and CTAS Nologging and insert command Tablespaces logging attributes RMAN and nologging operations References Continue reading
Moving from UTL_FILE_DIR to directories implementation Posted on January 29, 2013, updated on February 9, 2018 by Yannick JaquierTable of contents Preamble UTL_FILE_DIR Directories Continue reading
New 11gR2 relink command Posted on December 10, 2012, updated on January 26, 2016 by Yannick JaquierTable of contents Preamble Solutions Dedicated oraInst.loc file Overwrite oraInst.loc with variables References Continue reading
Who is locking your accounts (ORA-01017 and ORA-28000 errors) ? Posted on November 26, 2012, updated on June 18, 2015 by Yannick JaquierTable of contents Preamble ORA-01017/ORA-28000 with AUDIT_TRAIL ORA-01017/ORA-28000 without AUDIT_TRAIL Continue reading
Invisible indexes by example Posted on November 11, 2012, updated on June 25, 2015 by Yannick JaquierTable of contents Preamble Invisible indexes implementation Continue reading
Automatic SQL Tuning task overview Posted on October 31, 2012, updated on May 28, 2019 by Yannick JaquierTable of contents Preamble Automated tasks With command lines With Cloud Control References Continue reading