(John Hallas) I posted a routine on how to take a cold backup locally to disk and then restore it back in 2010. Last week I was asked in a comment ‘why did you have to open the database using resetlogs?’ A very good question I thought so I proceeded to backup and recover just as the blog showed and

(connormcdonald) Often, to do an existence check for data, people issue a “SELECT COUNT(…)” against the relevant table. So in pseudo-code, the logic looks like something like this:

(Fahd Mirza) There might be a situation where executing some DDL in pluggable database may cause the following error:

(John Hallas) I posted a routine on how to take a cold backup locally to disk and then restore it back in 2010. Last week I was asked in a comment ‘why did you have to open the database using resetlogs?’ A very good question I thought so I proceeded to backup and recover just as the blog showed and

(connormcdonald) Often, to do an existence check for data, people issue a “SELECT COUNT(…)” against the relevant table. So in pseudo-code, the logic looks like something like this:

(Fahd Mirza) There might be a situation where executing some DDL in pluggable database may cause the following error:

(Dominic Brooks) It is well-known that AWR, and Statspack before, take snapshots of V$ views (or rather the underlying objects) to produce the data in AWR.

(Dominic Brooks) It is well-known that AWR, and Statspack before, take snapshots of V$ views (or rather the underlying objects) to produce the data in AWR.

(Randolf Geist) Picking up from the first part of this instalment I’ll focus in this post on the available distribution methods for the new parallel FILTER subquery feature.

(Kris Rice) The github repo for all the things the DB Tools team does will be posted here https://github.com/oracle/Oracle_DB_Tools This will include sqlcl , sqldev, modeler, ords , and who knows what other things we have up our sleeves to post.