Changes in This Release for Oracle Database Utilities
This preface lists changes in Oracle Database Utilities for Oracle Database 18c.
- Changes in Oracle Database 19c
This topic lists changes in Oracle Database Utilities for Oracle Database 19c. - Changes in Oracle Database 18c
Changes in Oracle Database 19c
This topic lists changes in Oracle Database Utilities for Oracle Database 19c.
Note:
This preface is discontinued. Refer to Oracle Database New Features Guide for information about new features, and refer to Oracle Database Upgrade Guide for information about deprecated and desupported features.
- New Features
New Features topic provides the information about the features that are new in this release. - Desupported Features
The following features are desupported in this release.
Parent topic: Changes in This Release for Oracle Database Utilities
New Features
New Features topic provides the information about the features that are new in this release.
The following features are new in this release:
-
Oracle LogMiner
The
CONTINUOUS_MINE
functionality of the LogMiner package is obsolete. It was deprecated in Oracle Database 12c release 2 (12.2). There is no replacement functionality. -
REST APIs
In managed cloud services such as Exalogic Elastic Cloud Software (EECS) and Oracle Data Warehouse Cloud Service (DWCS), users do not have access to the operating system. They only have access to the database service. Loading data and migrating customers from on-premise to such a service is difficult. Customers can upload their Data Pump dump files to the object store and load them into the database using the new object store REST APIs.
Impdp
client CLI now accepts a new command line parameter calledcredential
.The
credential
parameter is the name of the credential object that contains the user name and password required to access the object store. When a user connects to the database to runimpdp
, the Datapump layer validates if the credential exists and the user has access to read the credential. If there are any errors, an error is returned back to theimpdp
client. -
Oracle Data Pump Export and Import
-
The DBAs can now import tablespace files mounted on two different databases as long as the files are set as
read-only
.KEEP_READ_ONLY
andNO_BITMAP_REBUILD
are added as TRANSPORTABLE parameter values. -
The DBAs can now more easily determine how long an export is going to take and discover unforeseen issues not reported by the closure check. The Data Pump Export command-line mode
TTS_CLOSURE_CHECK
parameter is used to indicate the degree of closure checking to be performed as part of a Data Pump transportable tablespace operation. -
A new transform parameter,
OMIT_ENCRYPTION_CLAUSE
is introduced that causes Oracle Data Pump to suppress any encryption clauses associated with objects using encrypted columns. -
A changed parameter,
MAX_DATAPUMP_JOBS_PER_PDB
can provide DBAs more control over resource utilization when there are multiple users performing data pump jobs in a given database environment. Default:100
, Range:0
to250
orAuto
- 50% of SESSIONS.A new parameter,
MAX_DATAPUMP_PARALLEL_PER_JOB
is introduced that provides the database administrators more control over resource utilization when there are multiple users performing data pump jobs in a given database environment.
-
-
Oracle External Tables
You can now create partitioned hybrid tables using ORACLE_LOADER access driver.
Desupported Features
The following features are desupported in this release.
The following features are desupported in this release:
-
CONTINUOUS_MINE feature of LogMiner
The
CONTINUOUS_MINE
option for thedbms_logmnr.start_logmnr
package is desupported in Oracle Database 19c (19.1), and is no longer available. -
Oracle Streams
Starting with Oracle Database 19c, Oracle Streams is desupported. Oracle GoldenGate is the replication solution for the Oracle database.
Parent topic: Changes in Oracle Database 19c
Changes in Oracle Database 18c
This topic lists changes in Oracle Database Utilities for Oracle Database 18c
Oracle Data Pump, Export, and Import
-
The Data Pump Import
DATA_OPTIONS
parameter has a newCONTINUE_LOAD_ON_FORMAT_ERROR
option. If Data Pump encounters a stream format error when loading table data, Data Pump attempts to skip forward to find the start of the next row and continue loading that data from that location.
-
For security purposes, Data Pump handles fixed user database links with passwords differently. For additional information, see Using Transparent Data Encryption with Other Oracle Features
-
Starting with Oracle Database 18c, you can include the unified audit trail in either full or partial export and import operations using Oracle Data Pump. For additional information, see Data Pump Components.
-
As of Oracle Database 18c,
XML_CLOB
option of the ExportDATA_OPTIONS
parameter is desupported.
Oracle LogMiner
-
The
UTL_FILE_DIR
initialization parameter is desupported. It is still supported for backward compatibility, but Oracle recommends that you instead use directory objects. This desupport affects extracting LogMiner dictionaries to flat files. See Extracting the LogMiner Dictionary to a Flat File.
DBMS_DATAPUMP PL/SQL Package
-
The
DATA_OPTIONS
parameter of theDBMS_DATAPUMP.SET_PARAMETER
procedure has a new option,KU$_DATAOPT_CONT_LOAD_ON_FMT_ERR
. This option tells Data Pump to continue loading data from the next row if it encounters stream format errors in the table data.
External Tables
-
External tables can be used as inline external tables in SQL statements, thus eliminating the need to create an external table as a persistent database object in the data dictionary.
Parent topic: Changes in This Release for Oracle Database Utilities