Questions

There is an requirement to get the DDL for Oracle fusion custom tables is it possible to achieve??...

Hi,is it possible to audit (unified auditing) access to tables only once per session? I don't need to catch all selects from audited tables in a session, I just want to to know if a table was at querried at least once. Currently it generates huge amount of aud...

connect system password : password. i got following errorsORA-01034: ORACLE NOT AVAILABLEORA-27101: shared memory realm does not exist...

hello guys,I'm trying to create hierarchy using a parent child table for analytic view but I'm struggling.the steps:1. create a attribute dimension using the table --> (id,name,parent_id)(I succeeded but idk the correct way for the parent child hierarchy).2.cr...

Where may I find the database installer for Windows 32-bit for Oracle 11.2.0.2?I did not find the 11.2.0.2 Windows version, only Linux....

I need to move online a huge table with BLOBs (around 25 TB) to a new tablespace with bigger block size.Wich method is recommended? Is DBMS_REDEFINITION still the method recommended by oracle? Or is now ALTER TABLE MOVE ONLINE?...

How to move a queue table into other tablespace in 11g database?Can we shrink queue table in 11g database?The dbms_redefinition is throwing error in moving to other tablespace as can't redefine.My tablespace datafiles are very much fragmented because of this q...

Ask Tom:I would like to migrate a PL/SQL Web Toolkit application from an on-prem database instance to the Oracle Autonomous Database. I see references to the PL/SQL Gateway via ORDS (I think) in documentation and administration screens but I'm struggling to co...

Hi everyone,We’re developing an APEX app that handles Excel files, and we’ve run into a problem when trying to export the app from one Workspace and import it into another.<b>The main issue:When we export the app and attempt to import it into a different Works...

Hi there,I am facing an issue wherein i need to have more than 1000 values in IN Operator of query.Please suggest some way around for the same .here is the code snippet for you.Note: RMID IN can have 1000+values .Also had tried using OR RMID IN ()-for values g...

I thought I could take what Chris showed me in my original question (https://asktom.oracle.com/ords/asktom.search?tag=looking-for-help-with-json-object).However, after 2 days, I have not made any progress.The JSON data - { "recall_control":[ { "it...

Hello,I am executing a package on multiple threads. Our package is for deleting data in bulk.Whenever I am running the package on multiple threads I am getting a deadlock.On checking the trace file I found the delete statement which is causing deadlock. But th...

Hello,We have migration project form Oracle database 11g in Exadata server, to 19c in ODA server, when we tested the query in the new server with client tool such as Sql developper, Sqlplus and Sqlcl, the connection was lost after 1 hour of inactivity, the onl...

Tom,How can we display PDF files stored in the database,using htp.p (OAS PL/SQL cartridge )calls and dbms_lob ?We are developing a document archival and display app.Using ctxload, I can upload the files. Now, I would liketo display the file in its native forma...

Hello,I wanted to ask about new 23C feature - Schema-level Privileges: is it possible to combine it with "WITH GRANT OPTION"?According to documentation https://docs.oracle.com/en/database/oracle/oracle-database/23/dbseg/configuring-privilege-and-role-authoriza...

<code>SQL> alter session set standby_max_data_delay=1;Session altered.SQL> show parameter standby_max_data_delaySQL> select * from v$parameter where name='standby_max_data_delay';no rows selectedSQL></code>Where can I see my current setting of standby_max_data...

I am using the following IIS Server for App server.ODP.NetOracle 10.2.0After 30 minutes of idle time i get the error ORA-03135: connection lost contact.The Error is same even if I use Sql*plus.I asked the network group to increase firewall to 4 hours which the...

I am trying to integrate Microsoft Office365 Outlook's SMTP with Oracle Apex 22.1(Running on Amazon RDS for Oracle 19c). I have used the following configuration on Apex:SMTP server name: smtp.office365.comSMTP port: 587Username: <my-email-id@outlook.com>Passwo...

Hi,Being a DBA, how can we verify if private database link created in application schema is working fine? If application schema's password is not known to DBA.We can verify public database link using select * from dual@public_db_link; How private db links can ...

Hello, I am just lost here. I have a very simple requirement using sql developer.I need to extract user creation script for a list of users.How on earth do I do this please help .Why have they made so simple things so difficult to do or even find.I click ...