hi Tom, when a remote table is referred in sub query then it is not retrieving the data and it throws error. refer the below sql, I am trying to get latest record, so I am doing order by DATEM in sub query and taking first record in outer sql. here, OWNERDOCUMENTS used in FROM cl...

Hi We are looking to take a schema(abc) from our database to to a different server with a new schema name. I am looking to find what are the dependencies on the abc schema in our packages/procedure/functions and is there anything else i should be looking at. regards, Balaji

Hello Ask-Tom-Team, I came across this Oracle documentation „Deploying Oracle RAC on Docker“: https://www.oracle.com/technetwork/database/options/clustering/rac-ondocker-bp-wp-5458685.pdf Specifically the sentence: OracleRAC on Docker supports the non-privilege mode feature. This...

Dear Ask Tom team memebers. Is it possible to to measure sql effectivity via computed throw away row count ? Its clear that optimizer tries to build the plan to minimize throw away rows for the next steps in the plan. So it tries to send only relevant rows to next operation. I ge...

Hello everyone, I am trying to create a CSV file and then attach it to an email and send the email but I am receiving the following error: PLS-00201: identifier 'APEX_DATA_EXPORT.T_EXPORT' must be declared Below is the code I am attempting to run: declare l_context apex_exec.t_co...