Questions

Hello Chris/Connor,Hope you are doing well.We are using ExaC@C with 19c databases at work and are exploring whether we can use PDB Snapshot Carousel and/or PDB Snapshot Copy feature.It might be just me but I am somewhat confused with the "art of possible" whil...

Tom,What is connection pooling ? Please, can you give an example(s) that show thorough understanding of the subject matter as related to either ODBC OR JDBC application connections to the oracle database. Your site is more important and most value to the li...

Does the "Host CPU" in the PDB AWR mean the CPU usage for the PDB, CDB or the host?...

Hi,I have created an application that is tracking a set of processes that are being run from a master table. When a process is completed, a flag in a column name PROC_EXEC_STATUS changes from N to Y for each process. I want my oracle apex application to refres...

Hi,I have a database with thousands of tables containing the same kind of information.I need to write a program to aggregate these informations and thought about using a sqlmacro.<code>-- This is a very simplified conceptcreate or replace function get_val (...

<code>-- Settingsselect banner from v$version;--Oracle Database 23c Free Release 23.0.0.0.0 - Develop, Learn, and Run for Freeselect * from v$nls_parameters where parameter in ('NLS_NUMERIC_CHARACTERS','NLS_TERRITORY','NLS_LANGUAGE');-- NLS_LANGUAGE ...

Hello Tom,I use Oracle Flashback features a lot. We have several development and test environments here and the combination flashback database + replay is priceless. My question is this: why don't we have a "flashback schema" feature ? I know you can simulate ...

<code>SQL> select banner from v$version where rownum=1;BANNER--------------------------------------------------------------------------------Oracle Database 19c EE Extreme Perf Release 19.0.0.0.0 - ProductionSQL> create table t1(id int generated BY DEFAULT ON ...

We use Business Objects against a database setup just for generating reports. This is an Exadata RAC with 2 nodes and ASM storage and all of the BO sessions login/connect to the same oracle user.During our last month-end, which coincided with quarter-end, we ...

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