看到群里有人提出一个需求，一张表数据量很大，只想导出其中一部分列。 无论是老版本exp还是数据泵expdp，Oracle都提供了QUERY的功能，这使得查询表中部分记录的功能可以实现，但是QUERY只能过滤行，而不能过滤列，Oracle数据泵会读取表中全部列的。 在12c中，Oracle为数据泵提供了VIEW功能，使得导出的时候可以根据视图的定义来导出表中的数据： SQL> select banner from v$version; BANNER ——————————————————————————– Oracle Database 18c Enterprise Edition Release 22.214.171.124.0 – Production SQL> CREATE TABLE T_TABLES AS SELECT * FROM ALL_TABLES; 表已创建。 SQL> create view v_tables as select owner, table_name, tablespace_name from t_tables … Continue reading →
One of the new features introduced in GoldenGate 12c Release 3 (126.96.36.199) is the Parallel Replicat feature. So now in addition to the Classic Replicat, Co-ordinated Replicat and Integrated Replicat options, we also have another replicat option available as well. The Parallel Replicat on the surface appears to be very similar to the Integrated Replicat […]
Microservices Architecture is a method or approach to developing applications where an application is deployed as a suite of independently deployed small modular services. Each module supports a specific business goal and uses a simple, light weight and well-defined interface to communicate with other sets of services. Oracle GoldenGate You need to be logged in […]
In earlier versions when we had to do an Oracle database table instantiation or initial load, we had to perform a number of steps – basically to handle DML changes which were occurring on the source table while the export was in progress. So we had to first ensure that there were no open or […]
New in Oracle GoldenGate 12.2 is the feature to detailed help about the usage of a particular parameter (INFO) as well as information about the active parameters associated with a running Extract, Replicat as well as Manager process (GETPARAMINFO) INFO In this example we see all the information about the use of the […]
In GoldenGate 12.2 we can now validate parameter files before deployment. There is a new utility called chkprm which can be used for this purpose.’ To run the chkprm utility we provide the name of the parameter file and can optionally indicate what process this parameter file belongs to using the COMPONENT keyword. Let us […]
In earlier versions the RMAN DUPLICATE database command was a push-based method. One of the new features in Oracle 12c is that it has been changed to a pull-based method which has many advantages. Let us note the difference between the two methods. In the earlier push-based method, the source database transfers the required database […]
Heres a quick look at some of the new features introduced in 188.8.131.52 around Pluggable and Container databases. PDB CONTAINERS Clause Using the CONTAINERS clause, from the root container we can issue a query which selects or aggregates data across multiple pluggable databases. For example each pluggable data can contain data for a specific geographic […]
Real -Time Database Monitoring which is a new feature in Oracle 12c extends Real-Time SQL Monitoring which was a feature introduced in Oracle 11g. The main difference is related to the fact that SQL Monitoring only applies to a single SQL statement .
In one of the the earlier posts we had discussed the GoldenGate 12c Integrated Apply or Integrated Replicat feature. It enables high volume transactions to be applied in parallel.
But it was only supported for Oracle databases and also required to be v…