Hi Tom! We have a large load every day from one table to another and I wanted to split it up into chunks and run parallel jobs to speed it up. I found that doing the split on rowid doesn't work on partitioned table. First I did it on partition level since this is how we load (par...

How to troubleshoot this error: [oracle@localhost ~]$ sudo setenforce 0 [sudo] password for oracle: [oracle@localhost ~]$ export ORACLE_BASE=/u01/app/oracle [oracle@localhost ~]$ export ORACLE_HOME=$ORACLE_BASE/product/19.0.0/dbhome_1 [oracle@localhost ~]$ export PATH=$ORACLE_HOM...

When I try to read data from a CSV file using an Oracle external table, I get the following error: ORA-29913: error in executing ODCIEXTTABLEOPEN callout ORA-29400: data cartridge error What are the possible causes of this error, and how can I fix it so that the external table ca...

dbms_output.put_line has limitation of 255 characters per line. How can I get out of this limitation, so that I can use dbms_output.put_line to have 480 character per line

Hello Connor/Chris, Hope you are doing well. Recently, I came to know about the PART_NAME parameter for multiple APIs of DBMS_REDEFINITION package from the documentation. However, I could not find much about what kind of changes are permitted (and prevented) at partition level, e...