Questions

I am trying to setup a database project that has three or so schemas that are named the same for most of the deployed environments but are different for one deployment. For example local development through production would have schema names schema1, schema2, ...

Hi. What is the technical reason why the package DBMS_DEBUG_JDWP is not available on the Oracle Autonomous Database? What does it do that makes calling it illegal in PL/SQL?Thanks,...

Hello Chris/Connor,I am trying to use the option MY_WALLET_DIRECTORY in TNSNAMES file in order to avoid having to specify WALLET_LOCATION in SQLNET.ORA file. However, it fails with ORA-01017: invalid username/password; logon denied error. Tracing the SQLNET (f...

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

Requirement: Dynamically assign the date value to the main cursor query to fetch data prior to past 3 business days. This is based on the day of the run of the concurrent programi.e. if the concurrent program is run on SYSDATE i.e. today. IT needs to pick up d...

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

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