Questions

I have a table with partitions and I would like to find the most efficient way to empty a clob column for an entire partition.I thought I could use DBMS_REDEFINITION with col_mapping and part_name but I am always getting ORA-42000.Here are the statements I am ...

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

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

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 calloutORA-29400: data cartridge errorWhat are the possible causes of this error, and how can I fix it so that the ...

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

I need to propagate changes on a few tables to an external system. I have to do it near realtime and ultimately it will end up on Kafka from my end. The solution target is Oracle 19c and needs to be installed to multiple clients on premises.Example problem:Let...

I am normally using "<code>SELECT DBMS_METADATA.GET_DDL('USER', 'User_Name') FROM DUAL;</code>" to get the hashed password ( which I use to re-create the user as it was ), with SYSTEM user.This unfortunately does not work for users which have password_versions...

Hello,I have a question regarding concurrent statistics gathering in Oracle 19c. Currently, my global preference is set to OFF:SELECT DBMS_STATS.GET_PREFS('CONCURRENT') FROM DUAL;-- Result: OFFI can enable it manually with:BEGIN DBMS_STATS.SET_GLOBAL_PREFS('C...

All,I have an Oracle view built on top of a partitioned table. Occasionally the view becomes INVALID, even though there are no DDL changes happening on the base table. The view becomes VALID again automatically when it is accessed or queried, but this behavior...

is Instances can exist without the database and database can exist without instance...

Hello i just wanted to ask you a question. Can you please provide me some good online oracle books, tutorials or courses of the dba technologies like RMAN, Golden Gates, Exadata, Data Guard, Data pump and RAC? thanks....

Well hello i just wanted to ask you when you have 100000000 rows of data and the best partitioning strategy is to use partition by range with subpartition by hash (having a column that is date type called hired and in the range we have YEAR(hired) and in the h...

Hi Tom,I was learning Secure Application Roles and created an example to test it. Everything worked fine to actually create and enable the role, but I'm getting an error disabling the role (actively disabling it, not just letting the end of session do it).Fir...

Hi,As part of capacity planning, customer is asking schema table size growth per year for last 10 years. Is there any way to get it?I tried the below query but through this we are not able to get size per year for last 10 years.SELECT ds.tablespace_name,ds.seg...

Well hello i just wanted to ask you a question. Before 1.5 years i installed 23ai version and i downloaded sql developer. Before 1 month i opened my sql developer and i saw that my hr user is locked so i had to connect to sys user and then i pressed the follow...

Hello,We have a Java process that calls OR stored procedure via JPA. This procedure was initially declared outside of a package, and everything worked fine, but when we moved it into a package, we encountered date conversion problems related to the incorrectly...

We don't seem to be able memoptimize a table for read when there are triggers on it (this seems to be undocumented however ?).But: we can add the triggers later on without problem and the table continues to be memoptimized for read.Question: WHY ? Is it a bug ...

Hi all,I have a hierarchy between levels in my_hierarchy table (between id_lvl and id_lvl_sup).Each level (lvl) may have items (id_item), and each item has a category (id_item_sup). These data is stored in my_items table.Now I want to build a report based on t...

<b>My goal</b> is to create a fast refreshable materialized view (MV) that holds all the combinations of records in specific related tables. So also the 'incomplete combinations'. So the query that is needed contains a full outer join.<b>First a disclaimer abo...