Blog Archives

Enabling / Disabling Flashback Database in 11gR2

Flashback database was introduced in Oracle 10g and offer’s a simple way for performing a point in time recovery. To enable this, your database must be running in archivelog mode and flash recovery must be enabled. In 10g We would

Posted in Blog Tagged with: , ,

Standalone Oracle Database Patching with ASM

Some Useful links: Information Center: Patching and Maintaining Oracle Database Server/Client Installations (Doc ID 1351428.2) Introduction to Oracle Recommended Patches (Doc ID 756388.1) Oracle Recommended Patches — Oracle Database (Doc ID 756671.1) Quick Reference to Patch Numbers for Database PSU,

Posted in Blog Tagged with: , , ,

EXPDP and IMPDP with Query and REMAP_TABLE

Here we have a table called requests under the SAMPLE schema, what we are going to do is export it and then re import changing its name and the tablespace with a filter. 1. Create export par file and export

Posted in Blog Tagged with: , , ,

Affiliations

Engagements

  • Oracle OpenWorld 2014
  • Gartner BI Summit 9/3/15-10/3/15
  • UKOUG Business Analytics SIG 12/3/15
  • UKOUG Conference 7/12/15-9/12/15
  • Oracle Ireland Conference 2016 3/3/16-4/3/16
  • UKOUG Systems 2016 12/5/16
  • Oracle OpenWorld 2016
  • POUG 2016 7/10/16
  • DOAG 2016 15/11/16
  • UKOUG 2016 5/12/16

Videos

Posts

  • 2017 (8)
  • 2016 (22)
  • 2015 (22)
  • 2014 (8)
  • 2013 (2)