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...

Hi Tom, It was run a impdp command with remap_table in parfile with sqlplus in Oracle Linux but it run a full import. We've lost impdp logs, How could we get information about the impdp command that was run and clarify the issue? Thanks a lot Regards!