new feature

数据泵导致表部分列

看到群里有人提出一个需求,一张表数据量很大,只想导出其中一部分列。 无论是老版本exp还是数据泵expdp,Oracle都提供了QUERY的功能,这使得查询表中部分记录的功能可以实现,但是QUERY只能过滤行,而不能过滤列,Oracle数据泵会读取表中全部列的。 在12c中,Oracle为数据泵提供了VIEW功能,使得导出的时候可以根据视图的定义来导出表中的数据: SQL> select banner from v$version; BANNER ——————————————————————————– Oracle Database 18c Enterprise Edition Release 18.0.0.0.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

Oracle GoldenGate 12c Release 3 New Feature Parallel Replicat

One of the new features introduced in GoldenGate 12c Release 3 (12.3.0.1) 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 […]

Oracle GoldenGate 12c Release 3 (12.3.0.1.0) Microservices Architecture

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 […]

Oracle GoldenGate 12.2 New Feature – Integration with Oracle Datapump

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 […]

GoldenGate 12.2 New Feature – INFO and GETPARAMINFO

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 […]

Goldengate 12.2 New Feature – Check and validate parameter files using chkprm

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 […]

Oracle 12c RMAN DUPLICATE Database

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 […]

12.1.0.2 Multitenant Database New Features

Heres a quick look at some of the new features introduced in 12.1.0.2 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 […]

Oracle 12c New Feature Real-Time Database Monitoring

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 .
V…

TEL/電話+86 13764045638
Email service@parnassusdata.com
QQ 47079569