OOW 18 Even the Aces’s make Mistakes – Truncate table

Today at OOW18, Do come to this session, a number of Aces and myself will go through some of the mistakes we have done 🙂

SESSION INFO Conference: Oracle OpenWorld Session Type: Tips and Tricks Session Session ID: TIP1989 Session Title: Even the ACEs make Mistakes – What did they learn?” Room: Moscone West - Room 3001 Date: 10/23/18 Start Time: 03:45:00 PM End Time: 04:30:00 PM

I will be talking about the deadly truncate table.  So, I accidentally truncated a table in production, what do we do? For a second panic.

Seriously this happened to me, and I did panic for a second. We were on Oracle 10g at the time - So what options did we have and what did we do.

  1. Import table – we could have done this, but the table would have been out of sync.
  2. Restore the full database into a staging area and roll the database forward ie point-in-time recovery.
    1. Export the table.
    2. Import the table into production.
  3. Restore the full database into production and roll the database forward.

At the time – when this happened, we were actually being audited by Oracle on our processes, No1 would have been a quick solution even though we could have lost some rows, but we decided to go with No 3.

All in all, it was successful and well - our DR procedure worked.

ODC Appreciation Day: Database In-Memory

This year I have been working mostly on Oracle Database In-Memory, so far have been impressed. As part of a project to move an analytical database to the cloud we have decided to use the In-Memory function. So far so good – it just works. Once the option is enabled a simple command loads the table into memory: Alter table w_expense_f inmemory priority critical; The columnar compression has worked really well for us, we have managed to get up to 85% compression on some tables. We are currently testing the performance against an exalytics system as well as TimesTen. So, watch this space

OUG Ireland & Promotion to Oracle Ace Director

I set out on Thursday at 4am to catch a flight for Dublin at 6.30am to attend the OUG Ireland Conference as I had a session I was presenting after lunch. This conference has grown over the years and I am sure the numbers of attendees are increasing every year, That's a credit to the organisers for the organisation UKOUG and the quality of the talks. It was great seeing everyone - speakers and delegates.
User group conferences are a great way to learn old and new technologies - you can never know everything. What I enjoy about speaking at these conferences is that I get to attend other sessions and learn something new 😃.
I missed the first few sessions as I was on a sev 1 web ex with oracle support over the conference WiFi, and was funny seeing Philippe also on a similar call. Work continues no matter where you are 😱. Once that was over I was mingling with everyone, I went to Mike's talk on 'Upgrading database to 12.2' - nice to see they are making upgrades easier. 😉.
After lunch it was my talk on the DataSync tool with a live demo - it was the first time with this new talk but went Ok.
Later I went to Christian's talk on 'Oracle Analytics and EPM' - it was interesting - I think he is a secret accountant 😉.
As the day came to a close, it was time for the social event. This is where we had some nibbles, drinks and jokes as well as chocolate tasting and some gin that Heli had brought with her. Once the social was over some of the speakers were out for the customary dinner together :). We went to a nice restaurant called the Rustic Stone.
Once everyone was seated, Brendan stood up and announced he had a special announcement and it was a promotion. The Ace Program had promoted me to 'Oracle Ace Director'. It had been a long day but a day that I will never forget and surrounded by great friends to share this moment😃 . This new way of announcing promotions is a nice touch. I couldn't attend the 2nd day as I had to be at the Oracle Dublin offices - working with development on resolving some work issues that needed attention and presenting about 'Analytics and Data in the cloud' to some of the staff.
In the end, an awesome conference and hope to return again...

Copying an existing configuration for Cloud DataSync

We are assuming you have already installed DataSync and you now want to copy an existing configuration you had already done on a another machine.

  1. Copy the entire folder path of the DataSync you want to copy and rename folder .._Old.
  2. Drill to new installed Datasync folder.
  3. Double click datasync.bat.

    Select Next

    Select Next

    Select the folder where the configuration exists that you want copied. Select OK

    Select Yes

    Select Next

    That's it you have copied a previous configured Datasync to your new environment.