Data Loading and ETL
Discussion List
-
DBMS_CLOUD.VALIDATE_EXTERNAL_TABLE unable to see validation errorsSummary Unable to see validation errors in either VALIDATE$21_LOG or VALIDATE$21_BAD tablesContent I have successfully created an external table in my schema, but when I…User_2025-02-08-03-47-01-847 36 views 9 comments 1 point Most recent by User_2025-02-08-03-47-01-847 Autonomous Database
-
DBMS_CLOUD.CREATE_EXTERNAL_TABLE handling accent marks in textSummary KUP-04021: field formatting error for field ADDRESSLINE1 when loading external table where text string contains special charactersContent Hi, I'm hoping you can …User_2025-02-08-03-47-01-847 9 views 4 comments 0 points Most recent by User_2025-02-08-03-47-01-847 Autonomous Database
-
Loading XML data into databaseSummary How to load a CSV file into database that contains a field with XML dataContent Hi, I'm hoping you can help. I have a CSV file containing textual and XML data, a…User_2025-02-08-03-47-01-847 14 views 4 comments 0 points Most recent by User_2025-02-08-03-47-01-847 Autonomous Database
-
DBMS_CLOUD.CREATE_EXTERNAL_TABLE file delimiter "+|"Summary Trying to setup an external table for a file which is delimited by "+|" and row delimited by "&|" but failing on validationContent Hi, I hope you can help me. I'…User_2025-02-08-03-47-01-847 27 views 9 comments 0 points Most recent by Yasin.Baskan-Oracle Autonomous Database
-
DBMS_CLOUD.CREATE_EXTERNAL_TABLE ignoring NULL columns tab delimited fileSummary External table is ignoring NULL columns on tab delimited file so contents are appearing in wrong columnsContent I have created an external table over a tab-delim…User_2025-02-08-03-47-01-847 15 views 4 comments 0 points Most recent by User_2025-02-08-03-47-01-847 Autonomous Database
-
GA ANNOUNCEMENT - Timezone Files Automatically UpdatedContent For time zone support, Oracle Database uses time zone files that store the list of all time zones. The time zone files for Autonomous Database are periodically u…Keith Laker-Oracle 13 views 0 comments 0 points Most recent by Keith Laker-Oracle Autonomous Database
-
GA ANNOUNCEMENT - ADB Supports Connecting to non-Oracle DatabasesContent Autonomous Database now supports using connections that are enabled via Oracle Database Gateway. Gateways are designed for accessing a specific non-Oracle Databa…Keith Laker-Oracle 15 views 0 comments 0 points Most recent by Keith Laker-Oracle Autonomous Database
-
GA ANNOUNCEMENT - Reference Architecture Patterns and Solution Playbooks Now AvailableContent The Architecture Center has been u[dated to include a new series of data warehouse patterns: Each reference architecture pattern will come with the following: be…Keith Laker-Oracle 25 views 0 comments 0 points Most recent by Keith Laker-Oracle Autonomous Database
-
GA ANNOUNCEMENT - Maximum File Size Increased For Transfer Object StoreContent The maximum file size limit for DBMS_CLOUD.PUT_OBJECT procedure when transferring files to OCI Object Storage has been increased to 50 GB. Note - there are diffe…Keith Laker-Oracle 49 views 0 comments 0 points Most recent by Keith Laker-Oracle Autonomous Database
-
GA ANNOUNCEMENT - ADW now supports ORC filesContent ADB has expanded object storage support in two important ways: it can now query ORC files as well as complex data types found in Parquet, ORC and Avro files. ORC…Keith Laker-Oracle 12 views 0 comments 0 points Most recent by Keith Laker-Oracle Autonomous Database
-
GA ANNOUNCEMENT - Support for SODA Documents and CollectionsSummary Autonomous Database now supports loading and using Simple Oracle Document Architecture (SODA) documents and collections. SODA allows developers to store, search,…Keith Laker-Oracle 15 views 0 comments 0 points Most recent by Keith Laker-Oracle Autonomous Database
-
Space usage at 120% unclear what is calculatedSummary On what does Oracle base itself for calculation of the space usage?Content I have a free account of the Cloud Autonomous DWH and experience that the used size is…
-
GA ANNOUNCEMENT - Metadata Extensions within DBMS_CLOUDContent DBMS_CLOUD has been extended with the following new subprograms: 1) LIST_FILES Function - lists the files in the specified directory. The results include the fil…
-
GA ANNOUNCEMENT - Partitioned External Tables now support Parquet and Avro FilesSummary CREATE_EXTERNAL_PART_TABLE procedure now supports both Parquet and Avro files formats.Content CREATE_EXTERNAL_PART_TABLE procedure now supports both Parquet and …Keith Laker-Oracle 23 views 0 comments 0 points Most recent by Keith Laker-Oracle Autonomous Database
-
GA Announcement: SQL Developer Web now supports data loadingSummary ADB Serverless has been updated with SQL Developer Web 19.2.1. SQL Developer Web now supports loading data into an existing table.Content ADB Serverless has been…Keith Laker-Oracle 16 views 0 comments 0 points Most recent by Keith Laker-Oracle Autonomous Database
-
GA Announcement: Support For Hybrid Partitioned Tables Now Available (19c Preview only)Summary Support For Hybrid Partitioned Tables Now Available (19c Preview only)Content Hybrid partitioned tables allows a query to access both internal data and multiple …Keith Laker-Oracle 13 views 0 comments 0 points Most recent by Keith Laker-Oracle Autonomous Database
-
GA Annoncement: Support for External Partitioned Tables Now AvailableSummary This new feature, external partitioned table, creates the ability to query multiple data files in the Object Store as a single external tableContent This new fea…Keith Laker-Oracle 23 views 0 comments 0 points Most recent by Keith Laker-Oracle Autonomous Database
-
Load data to ADW through DBMS_CLOUDContent Hi All, I am trying to load data into ADW from oracle object store through DBMS_CLOUD but getting below error . so how to debug below error. I think error is occ…
-
GA Announcement - Support for Directory ObjectsSummary ADB now supports multiple directories which makes it even easier for customers to migrate existing applications to ADBContent ADB now supports multiple directori…Keith Laker-Oracle 14 views 0 comments 0 points Most recent by Keith Laker-Oracle Autonomous Database
-
Oracle Autonomous Data Warehouse - Access Parquet Files in Object StoresSummary ADW can now access the data directly from the object store – providing people the ability to access data as soon as it lands – and then for optimized access load…Keith Laker-Oracle 12 views 2 comments 1 point Most recent by Keith Laker-Oracle Autonomous Database
-
Can WHERESCAPE RED connect to ADW?Content As ADW Supports only Wallet based connection, is there a way we can use Wherescape Red to load data into ADW? Thanks, MohitMohit Shimpi-Oracle 15 views 1 comment 0 points Most recent by Keith Laker-Oracle Autonomous Database
-
Unable to impdp 200GB schemaSummary impdp hangs but works for smaller tablesContent Hi everyone, I have just joined the Oracle Cloud environment last week and is now trying the ADW out. I transferr…Matthew Tian-158333 10 views 2 comments 0 points Most recent by Matthew Tian-158333 Autonomous Database
-
Creating Database Links from ADW to On-Prem or Other Databases on the CloudContent Autonomous Data Warehouse (ADW) supports outgoing database links to any database that is accessible from an ADW instance including on-prem databases, Database Cl…
-
GA Announcement - ADW now enabled with spatial intelligenceSummary Autonomous Data Warehouse has enabled the core set of Spatial functionality including the native spatial type, index, and associated core analysis operators and …Keith Laker-Oracle 14 views 0 comments 0 points Most recent by Keith Laker-Oracle Autonomous Database
-
GA Announcement - ADW now fully supports database linksSummary It is now possible to create a database link from ADW/ATP to any database that is accessible from ADW/ATP including other ADW/ATP instances.Content It is now pos…Keith Laker-Oracle 14 views 0 comments 0 points Most recent by Keith Laker-Oracle Autonomous Database
-
GA Announcement : Autonomous Database now supports pre-authenticated URLsSummary If source files reside on the Oracle Cloud Infrastructure Object Storage it is now possible to use Oracle Cloud Infrastructure pre-authenticated URIs.Content NEW…Keith Laker-Oracle 17 views 0 comments 0 points Most recent by Keith Laker-Oracle Autonomous Database
-
GA Announcement : Data Pump now uses native URLs with Autonomous DatabaseSummary In Oracle Data Pump, if your source files reside on the Oracle Cloud Infrastructure Object Storage you can now use the Oracle Cloud Infrastructure native URIsCon…Keith Laker-Oracle 5 views 0 comments 0 points Most recent by Keith Laker-Oracle Autonomous Database
-
GA Announcement : Oracle XML DB features are now supported in Autonomous Data WarehouseSummary Oracle XML DB features are now supported in Autonomous Database.Content Oracle XML DB features are now supported in Autonomous Database. This enables existing cu…Keith Laker-Oracle 4 views 0 comments 0 points Most recent by Keith Laker-Oracle Autonomous Database
-
Support Apache Avro Files now LIVESummary Autonomous Database can now read Avro files and parse the schema within the file to create the columns with the appropriate Oracle Database data typesContent Avr…Keith Laker-Oracle 13 views 0 comments 0 points Most recent by Keith Laker-Oracle Autonomous Database
-
Ability to Change License Type is Now LIVE!Summary You can now quickly and easily change the type licensing for your Autonomous Database from BYOL to a new cloud subscription or vice-versa.Content As of today (We…Keith Laker-Oracle 12 views 0 comments 0 points Most recent by Keith Laker-Oracle Autonomous Database