(Hemant K Chitale) The “data dictionary” for RMAN is in (a) V$ views from the controlfile and, if a Catalog Schema is implemented (b) Catalog Views.
Tag: Oracle
Enhanced purging of the Oracle recyclebin
(Jay Stanley) In the Oracle RDBMS v10, the ‘recyclebin’ for segments was introduced. If the recyelebin=on parameter is set, and a table is dropped, it is not actually dropped – it is renamed to a system-generated name. This can really help in situations where a table is accidentally dropped, as it c
CloneDB in Oracle 12.1.0.2
(Martin Bach) I personally really like CloneDB, a way to thin-clone an Oracle database over NFS. This can be quite interesting, and I wanted to update my blog for 12.1.0.2.3 (April PSU). Tim Hall has a good example for 11.2.0.2 and later with further references.
Oracle 12C Problem with datapatch
(Neil Chandler) I was minding my business, patching an Oracle 12C RAC Cluster when the darned patch failed
Formatting your SQL Queries, Indented Predicates on New Lines
(Jeff Smith) Someone asked in our forums how to format their code the way they want it.
CloneDB in Oracle 12.1.0.2
(Martin Bach) I personally really like CloneDB, a way to thin-clone an Oracle database over NFS. This can be quite interesting, and I wanted to update my blog for 12.1.0.2.3 (April PSU). Tim Hall has a good example for 11.2.0.2 and later with further references.
Oracle 12C Problem with datapatch
(Neil Chandler) I was minding my business, patching an Oracle 12C RAC Cluster when the darned patch failed
Formatting your SQL Queries, Indented Predicates on New Lines
(Jeff Smith) Someone asked in our forums how to format their code the way they want it.
SOA Suite 12c: Collect & Deploy SCA composites & Service Bus artifacts using Maven
(Maarten Smeets) An artifact repository has many benefits for collaboration and governance of artifacts. In this blog post I will illustrate how you can fetch SCA composites and Service Bus artifacts from an artifact repository and deploy them. The purpose of this exercise is to show that you do not
SOA Suite 12c: Collect & Deploy SCA composites & Service Bus artifacts using Maven
(Maarten Smeets) An artifact repository has many benefits for collaboration and governance of artifacts. In this blog post I will illustrate how you can fetch SCA composites and Service Bus artifacts from an artifact repository and deploy them. The purpose of this exercise is to show that you do not
