Questions

HelloIs there any method to get the MIME type of BLOB data file using plsql?Ex for PDF - application/pdffor xlsm - application/octet-stream etcFor reference you can take fnd_lobs table in Oracle Applications....

Hi I am using Datapump to export dump file from a database and while exporting the dumpfile, I am splitting that dumpfile into multiple files. Now I want to transfer those files to another server using DBMS_FILE_TRANSFER.PUT_FILE. I know I can explicitly menti...

Hello,I am looking for the OpenAPI 3.0 of the GoldenGate API 21.3We only found the Swagger 2.0 file from this URL : https://docs.oracle.com/en/middleware/goldengate/core/21.3/oggra/swagger.jsonThank you for your help....

Hi,The documentation https://docs.oracle.com/en/database/oracle/oracle-database/19/ostmg/asm-filegroups.html#GUID-BE9083C8-A5DF-48CD-BB32-C8A6FCDA3E7Bsay about redundancy PARITY: "not supported on data files".But what if i have ReadOnly tablespace? I'd like to...

Hi All,Can the Deletes be used in place of SELECT in CTE ?(below code snippet is a sample)<code>--selectwith cte_sample as (select date from example)SELECT * from calendar_extract where date in (select date from cte_sample);--deletewith cte_sample as (select d...

How does Oracle's flashback technology utilize flashback logs to enable point-in-time recovery, and what limitations should DBAs be aware of?...

Hello,I work as a dba and get requests from developers to create tables which we often review and sometimes change for better design and/or implementation.One of the developers recently sent a request to create a table such as the following ;table_name:t1_rela...

how to download a free oracle magazine in pdf about getting latest oracle database and it's technology relevant information as like MSDN of microsoft....

Tried all the steps nothing is helping : Gave all grants :Used this as an Admin : select * from dba_credentials; grant write on directory data_pump_dir to X_GC_DW; grant read on directory data_pump_dir to X_GC_DW ; SELECT * FROM dba_tab_privs WHERE table_n...

This is my example data:<code>CREATE TABLE xml_test ( xml_col XMLTYPE NOT NULL);/* */INSERT INTO xml_test VALUES (XMLTYPE('<ns1:SomeRootNode xmlns="http://www.exampleurl.com" xmlns:ns1="http://www.someotherurl.com"> <ns1:SomeParentNode> <ns1:SomeRepeati...

After updating to v25.x.x of the Oracle SQL Developer extension for VS Code, I noticed that SET DEFINE OFF only works when I run the script (F5) in the first line. In previous versions, SET DEFINE OFF worked regardless of where the script was executed.Is this ...

Hello Community, I have 5+ yrs of experience. I am trying for a job change. While attending interviews i can able to answer all theoretical questions and queries but i couldnt able to answer senario based questions. How can i level up my preperation as i am on...

Hi,Does Oracle have any plans to support RS256 in Apex ? Thanks https://apexapps.oracle.com/pls/apex/r/apex_pm/ideas/details?idea=FR-4418&session=105003035734261...

Hi, I am working on a RAC 19C with two nodes. When the database is brought up, I get an ORA-700 [sms physmem limit] error in the alert log. To fine-tune the various parts of VM, OS and DB, I referred to Oracle Doc ID 2610312.1. It says that SGA_MAX_SIZE+PGA_AG...

Hello Tom,I’ve been assigned a task where I need to check whether a table has any child tables, and if so, list them.For example, if the table name is ABC, I should be able to list all its child tables. I’m working in SQL Developer.My question is: is there a s...

I have a Merge statement, i got an error couple over weekend run. we did not get this error prior to last week and neither this week. just got this once.valdoiated that there were no DDL's or DML's were done at the same time.what could be the issue ...

Hello, I’ve set up Social Login authentication using the Keycloak service. We’re in a cloud environment hosted on AWS. The AWS WAF is blocking the request that APEX makes for authentication because the request does not contain a User-Agent. I’m getting a 403 e...

We have an Oracle Forms / Database application and were asked to limit User's maximum online time to 15 minutes. Following this, we set the profiles' CONNECT_TIME to 15 - this works well.How is it possible to reset this if user does any action on frontend?Mayb...

Which PL/SQL package is primarily used for interacting with Generative AI services in Oracle Database 23ai?DBMS_AI or DBMS_ML or DBMS_VECTOR_CHAIN or DBMS_GENAI?...

Hi there!I've some trouble trying to upload data from agent to OMS server, everything seems correct but:<b>emctl upload agentOracle Enterprise Manager 24ai Release 1Copyright (c) 1996, 2024 Oracle Corporation. All rights reserved.-----------------------------...