Tip
Discussion List
-
All Always Free 21c instances have been decommissionedPlease note that all Always Free 21c instances have now been decommissioned and are no longer available. Some instances may still be visible on your OCI console but you … -
Unable to copy JSON data from OCI Object storage to DB tableSummary: I have a JSON payload in OCI Object Storage and is available through public URL.I am trying to copy this data to an existing table TEST_TABLE_MAIN Question1) Th… -
I keep getting an error to upgrade. Is there a fix for itSummary: I was on a free trial period, and I want to upgrade, but when attempting to upgrade it tells me that it fails due to the below: I have checked the address of my…
-
can administrative user accounts be alteredSummary: I'm advising our internal Audit team about activities in ATP. They see administrative accounts like SYS and ADMIN. I'm trying to find documentation that states …Aaron Baker - Hanger, Inc 31 views 4 comments 0 points Most recent by Keith Laker-Oracle Autonomous Database
-
Storage limit allocated x storage used.Hello. I am a user of the Autonomous Database with APEX for just over 1 year in the Always Free layer, and I realized that the allocated storage increases significantly …
-
Cannot create Data Share on Autonomous Data WarehouseSummary: I am trying to create a Data Share in ADW but when I try to select the Cloud Location the dropdown list button does not work. I tried creating different Cloud S…
-
Unable to write file on OCI bucket with Header row from DBMS_CLOUD.EXPORT_DATASummary: Hi, I am writing a file from ATP (table) to the bucket in the OCI object storage it's working fine but the header row is not inserted. Please help to export the… -
Connect to ATP Database from ExcelSummary: Want to connect to ATP Database from Excel Content (required): Hi, Found below note to connect to ATP DB from Excel, but we don't find option to download 'Add-i…
-
Is it possible to use Oracle Database API for MongoDB to run rocket.chat?Summary: I am trying to connect RocketChat with Oracle-DB, but get error "MongoServerError: Invalid index specification: text index only support on wildcard" Content (re…
-
Production Live with Free Tier ATPSummary: Hi Team, Has anyone gone LIVE in production with Free Tier ATP. Do you see any challenge with that. Our data volume is less and 20 GB is enough. So just looking… -
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 -
Newsletter for Autonomous Database on Shared Infrastructure (July 22-2020) is now availableContent Latest newsletter for Autonomous Database on Shared Infrastructure (July 22-2020) is now available on the Data Warehousing blog: https://blogs.oracle.com/datawar…Keith Laker-Oracle 19 views 0 comments 0 points Most recent by Keith Laker-Oracle Autonomous Database
-
GA ANNOUNCEMENT - ADW Deployment Patterns in OCI Resource ManagerContent The list of pre-built Stacks within OCI Resource Manager has been expanded to include some of the new reference architecture patterns that support this year's Mo…Keith Laker-Oracle 15 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
-
Newsletter for Autonomous Database on Shared Infrastructure (June 24-2020) is now availableContent Latest edition of the newsletter for Autonomous Database on Shared Infrastructure (June 24-2020) is now available here: https://blogs.oracle.com/datawarehousing/…Keith Laker-Oracle 20 views 0 comments 0 points Most recent by Keith Laker-Oracle Autonomous Database
-
GA ANNOUNCEMENT - Latency Metrics Now Available in Service MetricsContent The Database Service Metrics information help Cloud Admins measure useful quantitative data about their Autonomous Databases. This list of available metrics now …Keith Laker-Oracle 24 views 0 comments 0 points Most recent by Keith Laker-Oracle Autonomous Database
-
GA ANNOUNCEMENT - Performance Hub Now Has a Timezone SelectorContent A time zone control has been added to Performance Hub. This will allow users to view data using an alternate time zone to UTC. They will have the choice of viewi…Keith Laker-Oracle 63 views 0 comments 0 points Most recent by Keith Laker-Oracle Autonomous Database
-
GA ANNOUNCEMENT - Workload Metrics on Performance HubSummary Performance Hub has been expanded to include a new tab, "Workload". This can be used to monitor the workload in the database and helps the user identify performa…
-
GA ANNOUNCEMENT - Support For Customer Managed Oracle REST Data ServicesSummary You can now use a customer managed environment if you want manual control of the configuration and management of Oracle REST Data Services.Content NEW - ADB now …
-
GA ANNOUNCEMENT - ADW Extensions for IDEsSummary Oracle extensions enable developers to connect to, browse, and manage Autonomous Databases in Oracle Cloud directly from their IDEs. There are extensions for fol…
-
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
-
GA ANNOUNCEMENT - ADW no delivers per-second billing!Summary Autonomous Database instance CPU and storage usage is now billed by the second, with a minimum usage period of 1 minute.Content Autonomous Database instance CPU …
-
GA ANNOUNCEMENT - Autonomous Database Now Supports Private EndpointsContent It is now possible to restrict access to Autonomous Database by specifying a private endpoint within a Virtual Cloud Network (VCN). Configuration of private acce…Keith Laker-Oracle 28 views 0 comments 2 points Most recent by Keith Laker-Oracle Autonomous Database
-
NEWSLETTER - Autonomous Database Newsletter - February 26-2020Content The latest edition of our customer newsletter for Autonomous Database on Shared Exadata Infrastructure is here: https://blogs.oracle.com/datawarehousing/autonomo…Keith Laker-Oracle 24 views 0 comments 0 points Most recent by Keith Laker-Oracle Autonomous Database
-
GA ANNOUNCEMENT - Send Emails Using ADBContent Autonomous Database now includes the UTL_SMTP package. This makes it possible to send emails via PL/SQL from within Autonomous Database. However, note that the o…Keith Laker-Oracle 35 views 0 comments 3 points Most recent by Keith Laker-Oracle Autonomous Database
-
GA ANNOUNCEMENT - REST APIs Added to DBMS_CLOUDContent The DBMS_CLOUD REST API functions provide a generic API that lets you call any REST API with the following supported cloud services: * Oracle Cloud Infrastructur…Keith Laker-Oracle 19 views 0 comments 0 points Most recent by Keith Laker-Oracle Autonomous Database
-
tnsnames.ora file contains other database related net service namesContent Is this fine? When we want to connect to a database & by mistake if we chose other database tns alias name, connection will happen as tnsnames.ora is having othe… -
ATP - how to access the dataSummary how to access dataContent Hi, what is recommended approach to access the data in ATP database. Using REST service what oracle cloud technology should be used. I …
-
GA Announcement - ADW is now available with support for Oracle REST Data ServicesSummary Oracle Rest Data Services (ORDS) is now included with Autonomous Data Warehouse.Content Oracle Rest Data Services (ORDS) is now included with Autonomous Data War…Keith Laker-Oracle 15 views 0 comments 0 points Most recent by Keith Laker-Oracle Autonomous Database
-
Getting started workshops and Cloud Test drive for ADW & TPSummary Autonmous DatabasesContent Please check this out https://blogs.oracle.com/imc/getting-started-workshops-for-autonomous-dw-tp Enjoy