SQL and Analytics
Discussion List
-
How we can query to dba_object table in ATP?Hello. Is there any way to query dba_objects, dba_sources, dba_tables table in ATP dabase?. According we check with the ADMIN user we don't have granto query this tables…
-
ATP DB Schema RenameSummary: I am seeking your expert advice on a significant change that we are planning to take. Could you kindly share any recommendations regarding the following scenari…
-
Linking Oracle Object Storage File as External Table in ADWHi, I work on the EPM side of things normally, but recently signed up for a free OCI account to test out ADW functionality (since this functionality is coming as a free …
-
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…
-
Your Free Guide to Everything Autonomous at Cloudworld 2024To get you ready for CloudWorld 2024 in Las Vegas, I have put together a quick must-see guide covering all the important sessions, workshops, and tutorials by the Autono…
-
Why occurs this error "ORA-01841: (full) year must be between -4713 and 9999, and not be 0"?Summary: When I try to do a SQL with a parameter date occurs this error "ORA-01841: (full) year must be between -4713 and 9999, and not be 0" SQL: select * from GL_DAILY…Franklin_Cardozo-Oracle 21 views 1 comment 0 points Most recent by Debadrita Ghosh-Oracle Autonomous Database
-
SQL developer web with Multiple TabsSummary: When using SQL developer WEB upon a ADB, only one tab of SQL code is allowed; my organization needs possibility to have multiple tabs to launch queries in paral…
-
ATP auto indexing consumes more than 16GB in SYSAUXDear valued Oracle DBA community, after enabling Oracle Autonomous auto indexing feature some months ago for testing purposes, I recently realized that since this time S…
-
How to solve this error of Oracle apex- 1403-no data found - rest data sourceSummary: Hi Experts, we are trying to upload file into OCI Object storage from Apex, so we created web credentials, rest data source and pages for uploading file. when u…
-
How can I prevent or further debug this ORA-00600?Summary: ORA-00600: internal error code, arguments: [cvwtynmBasic1], [cannot find datatype entry in internal table], [252], [], [], [], [], [], [], [], [], [] Content (r…
-
ADB URL for Oracle Autonomous Database Excel add-inSummary: Please can someone provide steps on how to get the specific ADB URL from the admin console. A video of the entire connection setup process with an example would…
-
Transparent Data EncryptionWe are trying to use Transparent Data Encryption for encrypting columns in Oracle ATP database. we have used the below query for creating a table with encrpted column, b…Narayanan V-Oracle 63 views 4 comments 0 points Most recent by Venkat Koduvayur-Oracle Autonomous Database
-
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 64 views 1 comment 0 points Most recent by Sarma NS-Oracle Autonomous Database
-
Do I need to update Wallet after service disruption?Summary: Oracle Cloud Toronto area has been disrupted for more than 24hr. My application still cannot connect to Oracle DB even https://ocistatus.oraclecloud.com/ says A…
-
Any one enabled auditing on select on a specific table? How to enable it? Where to find the results?Summary: Content (required): Version (include the version you are using, if applicable): Code Snippet (add any code snippets that support your topic, if applicable):Bheeshma 21 views 2 comments 0 points Most recent by Kuljeet Singh - Oracle-Oracle Autonomous Database
-
How to parse json array of strings.Summary: I've been working JSON tables and querying them. I've just run across a data structure that I cannot figure out how to parse. Content (required): The json array…
-
How do we install external python packages in OML4Py?Summary: Currently user installed packages are not supported in ADW OML4Py. This will be a very nice feature to have to take the advantage of large collection of open so…Venkat Koduvayur-Oracle 71 views 3 comments 0 points Most recent by Venkat Koduvayur-Oracle Autonomous Database
-
Receiving 500 Internal Server Error after passing one row of values through a POST APISummary: Content (required): Hi team, I have been receiving a 500 internal server error after passing a row of values through a POST REST API (through POSTMAN) in Oracle…
-
Is OLAP available on Oracle ADW?Exploring a migration from SQL Server to ADW and need to know if OLAP or similar functionality is available Content (required): Hello, We're exploring a migration from S…Brian Watkins-Oracle 131 views 4 comments 0 points Most recent by Bud Endress - Oracle-Oracle Autonomous Database
-
How to connect Oracle ADW with JDBC url in data management using EPM Agent?Content Hi Team, We had the data and metadata integration with DBCS (Database cloud services) using EPM Agent. But, now we have opt for Oracle ADW (Oracle Autonomous Dat…
-
Autonomous Database Now Supports SQL Tracing To Cloud Object StoreContent If you are an experience Oracle developer or DBA then you will know all about the benefits of using SQL tracing and how it can help identify the source of an exc…Keith Laker-Oracle 22 views 0 comments 1 point Most recent by Keith Laker-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
-
Getting ORA-01403:no data foundContent Hi Team I am trying to use flows for apex with my current apex application . I have created a simple flow with Approval Hierarchy with an User task to create a p…
-
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
-
Can an APEX page generate a URL link?Content Hi team, I just want to know, can an APEX page generate a URL link so that an external application can redirect to that particular APEX page? So there is this mi…
-
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…Keith Laker-Oracle 19 views 0 comments 2 points Most recent by Keith Laker-Oracle Autonomous Database
-
API made inside APEX fetching limited rowsContent Hi team, As I have created a table and an API whose operation is to get all the rows, the API is made using Restful Services inside APEX and the SQL query put is…
-
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 22 views 1 comment 0 points Most recent by Keith Laker-Oracle Autonomous Database
-
to integrate MS SQL Server dB with ADWContent Can we integrate SQL Server dB with Oracle ADW using Oracle Application Integration where operations like POST,GET,PUT can take place between ADW and SQL Server …
-
Accessing ADW without using APEX or SQL Dev tool to create REST APIsContent Hi team, Can we access Oracle ADW through some other tools and by not using its own components like Oracle APEX or Oracle SQL Web Developer tool to make REST API…