Data Loading and ETL
Discussion List
-
ORA-20000: No Oracle File System mounted (DATA_PUMP_DIR)Summary: We are facing the same issue with, p3consulting - https://community.oracle.com/customerconnect/discussion/722932/no-oracle-file-system-mounted for both our free… -
Data Transform: in the Create Data Flow Popup Window, the save button is disableSummary: I try to follow the livelab: Data Studio - Self-service tools for everyone using Oracle Autonomous Database In the Lab 7, Step 3. After I choose the connection …
-
ADW not showing sysdate correctly as per timezoneContent Hi Team, We have deployed ADW in a shared infra and currently facing issues to show "sysdate" correctly as per the customer defined timezone. Our DB timezone par…Venkat Koduvayur-Oracle 24 views 5 comments 0 points Most recent by Debadrita Ghosh-Oracle Autonomous Database
-
Connect MYSQL Database in APEXSummary: I have a requirement to connect with external MYSQL database and bring the data to Oracle Database Cloud. Content (please ensure you mask any confidential infor…
-
ANNOUNCEMENT - ORACLE-MANAGED CONNECTIVITY TO SERVICENOWOVERVIEW Autonomous Database support for Oracle-managed heterogeneous connectivity makes it easy to create database links to non-Oracle databases. When you use database … -
UPCOMING WEBCAST: Delivering successful Data Lakes with Autonomous Data WarehouseSummary: WEBCAST with live Q&A: Delivering successful Data Lakes with Autonomous Data Warehouse Date: Wednesday June 7 @ 11:00AM ET / 4:00 PM BST / 5:00 PM CET Registrat…
-
WEBCAST - Delivering successful Data Lakes with Autonomous Data WarehouseSummary: WEBCAST with live Q&A: Delivering successful Data Lakes with Autonomous Data Warehouse Date: Wednesday June 7 @ 11:00AM ET / 4:00 PM BST / 5:00 PM CET Content (…
-
ANNOUNCEMENT: February's newsletter covering all the latest new features in Autonomous DatabaseList of all the new features recently added to Autonomous Database (too many to list) in our regular "What's New" newsletter - https://blogs.oracle.com/datawarehousing/p…Keith Laker-Oracle 61 views 2 comments 2 points Most recent by Jayendra G-Oracle Autonomous Database
-
Can DBMS_CLOUD.COPY_DATA function picks up all the columns from the target table automatically?Summary: Hi Team, I am trying to load a JSON zipped file placed in Object Storage to a ADW DB Table using the DBMS_CLOUD package. Below is the sample code - DECLARE tabl…
-
Star TransformationIn a shared ADW instance, does the Star Transformation works? If yes, then how can we make sure that the same can be enable for the SELECT statements. Is it by setting v…SaurabhJaiswal-Oracle 61 views 1 comment 0 points Most recent by Sarma NS-Oracle Autonomous Database -
Unable to launch Data Transforms tool inside Database Actions of Oracle ADW after deploying ODI Web.Summary: Content (required): Hi team, After successful provision of Oracle Data Transforms instance, I am able to access the Data transforms from the web browser and aft…
-
Migrate data from Oracle DB 11.2.0.1 to ADWSummary: How migrate data from Oracle DB 11.2.0.1 to ADW Content (required): Hi, How can migrate data from Oracle DB 11.2.0.1 to ADW in the simplest way? I try with db-l…
-
How do I create an object storage to be used during data importsSummary: I only have Database Actions but have no access on the storage so I can't upload my data export from my DBaas database. Content (required): Version (include the…User_GISZA 21 views 3 comments 0 points Most recent by Kuljeet Singh - Oracle-Oracle Autonomous Database
-
ADW ArchitectureContent Hi team, Are there any resources regarding architecture of ADW, whether the architecture of ADW comprises of any 2-tier or 3-tier layer? Thanks and Regards Ankan
-
DBLink to be created from ADW to a OCI DBContent WE are trying to create a DBLink from ADW to OCI DB but failed. We followed the following two documents: 1. Create and Configure Database Link in Autonomous Data…Rehan Ahmed Khan-Oracle 24 views 1 comment 1 point Most recent by Keith Laker-Oracle Autonomous Database
-
GA ANNOUNCEMENT: New Database Actions Tools - Self-Service Data Warehousing for EveryoneContent Autonomous Database Tools Are Now Fully Available Autonomous Database now includes tools for quickly and easily loading data, building zero-code data transformat…
-
how to write a file using a query in atp databaseSummary how to write a file using a query in atp databaseContent how to write a file using a query in atp database and have that file stored in object storage area. rega…Hanuman Chennamsetty 15 views 1 comment 0 points Most recent by Keith Laker-Oracle Autonomous Database
-
Oracle DataSafe Product Enhancement IdeasSummary Oracle DataSafe Product Enhancement IdeasContent Hi Team, We have been using Oracle DataSafe on ADW for sometime now. We use Data Masking functionality extensive…
-
GA ANNOUNCEMENT - Changes To Access Methods for Files In S3 And Azure Blog StorageContent It is now possible to use a pre-signed URL in any DBMS_CLOUD procedure that takes a URL to access files in Amazon S3, without the need to create a credential. It…
-
GA ANNOUNCEMENT - Oracle Cloud Infrastructure SDK for PL/SQLContent The Oracle Cloud Infrastructure SDK for PL/SQL enables you to write code to interact with Oracle Cloud Infrastructure resources, including Autonomous Database. T…
-
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…
-
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 …
-
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…
-
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'…
-
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…
-
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…
-
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…
-
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…
-
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…
-
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…