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

what is the difference between logging and nologging when creating an index...

ORDS Landing Page Shows "ok" For Apex And Sql Developer Instead of "GO" button. I can't access to apex workspace page.when i click on the "ok" it toke me to apage shwing "not found http status code :404 Impossible to meet the requirement with a database. Veri...

My question is if they add the column the table will be block during the coluum add because it's not enteprise but standard edition...

Recently we observed that cached sequence values were lost significantly, appearing as large gaps in persisted values.Our system does not expect gapless sequence values, however we are trying to understand root cause.gv$rowcache shows high getmisses in histogr...

We are planning to migrate our database from on-premises infrastructure to ODA. The source platform is Solaris sparc, and the target platform is x86. We intend to use the M5 Cross-Endian Platform Migration approach.However, we have a question regarding whether...

Hello,I have an Oracle Advanced Queuing queue and would like to be able to process this queue from inside of the database, as opposed to using an external app server. However, I am concerned about the scalability of internal solutions.Please assume the followi...

Is there a way to create a On-premise MCP for oracle database without using OCI as a gateway? I want to deploy a real server (vm/container etc) rather than running a local instance of SQLCL on a user desktop that way we are able to configure the agent framewo...

I conducted an experiment with the recyclebin parameter.First, I set recyclebin = OFF to observe the behavior of a regular DROP TABLE.As I understand the architecture:there is a tablespace and a segment, for example T1.Information about this segment is stored ...

Hi Tom, I have created a TYPE as: Create or replace type NUM_ARRAY as table of varchar2(1000);Then I have a procedure which accepts an ARRAY of sql statements and executes one at a time. Now this take a lot of time to process a batch of sql statement.I wa...

I'm using Apex 23.1 and I want to add a new font family in Tiny MCE with url file reference ! here's what I've done :1- in Initialization JavaScript Function section<code>tinymce.init({ /* ... */ font_formats: "Andale Mono=andale mono,times; Arial=arial,helv...

Hello,If we are using Oracle SE2 there is no Tuning Pack or Diagnostic Pack available.So I don't think it's possible to create a SQL profile with SQL Tuning Advisor. would it be possible with SQLTXPLAIN coe_xfr_sql_profile.sql script ?I know it's possible to c...

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

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

We have PL/SQL stored procedures that perform poorly, Using DBA_HIST or any other AWR / ASH metrics, is it possible to determine the runtimes of PL/SQL Procedures ? ...

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

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

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