This feature requires that the Oracle Advanced Compression option be enabled. To use these compression algorithms, the COMPATIBLE initialization parameter must be set to at least 12.0.0. If you use words in identifiers that are reserved by the ORACLE_DATAPUMP access driver, then they must be enclosed in double quotation marks. Reserved Words for the ORACLE_DATAPUMP Access Driver.Restrictions When Using the ORACLE_DATAPUMP Access Driverīe aware of restrictions that apply to accessing external tables with the ORACLE_DATAPUMP access driver. Learn how to improve ORACLE_DATAPUMP access driver performance. Performance Hints When Using the ORACLE_DATAPUMP Access Driver.You can use the ORACLE_DATAPUMP access driver to unload and reload data for some of the unsupported data types The ORACLE_DATAPUMP access driver resolves many data types automatically during loads and unloads. Unloading and Loading Data with the ORACLE_DATAPUMP Access DriverĪs part of creating an external table with a SQL CREATE TABLE AS SELECT statement, the ORACLE_DATAPUMP access driver can write data to a dump file.When you create the ORACLE_DATAPUMP access driver external table, you can specify certain parameters in an access_parameters clause. The information that you provide through the access driver ensures that data from the data source is processed so that it matches the definition of the external table. To modify the default behavior of the access driver, use ORACLE_DATAPUMP access parameters. Using the ORACLE_DATAPUMP Access Driver.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |