Skip to Main Content

Questions

QuestionUpdatedAsked

Hi Tom / Team,I am connecting to the oracle server through dot net Oracle Data Provider dll Oracle.DataAccess(V 4.112.3.0) where I make a stored procedure call which essentially makes a database insert to a table and returns the id of newly created record usin...
3 hours ago6 days ago

Hi, I saw various sort options in tkprof.sort=(prsela,exeela,fchela)sort=PRSDSK, EXEDSK, FCHDSKsort=EXECPU,FCHCPUsort=(exeela,fchela)I really want to get poorly performing queries on the top. and then i want to print 10 top most poorly written queries from t...
4 hours ago5.1 years ago

HI,I created a bat file to run sqlldr to load the data from a csv file into Oracle,and I want to execute it automatically ,so I tried it by DBMS_SCHEDULERexec DBMS_SCHEDULER.run_job('DAILY_LOAD');Rapport d'erreur -ORA-27369: échec du travail de type EXECUTABLE...
4 hours ago3.6 years ago

We are unable to install 18c Expression Edition in Windows 10 it is extracting and in middle, it is start rollback. Finally below the below message. Below is the message.The wizard was interrupted before Oracle Database 18c Express Edition could be completely...
4 hours ago2.1 years ago

Hello Chris, Hello Connor.I have a view with a schedule of some kind of launches:<code>create or replace view v_schedule as select trunc(sysdate) + interval'1'minute * level as plan_date from dual connect by level <= 100000</code>And a log of actual launch dat...
15 hours ago6 days ago

Sorted input:<code>select regexp_replace( 'three0, three, two, two, two2, two3, three, three, three, one1, one1', '([^,]+)(,\1)+(,|$)', '\1\3') from dual;three0, three, two, two2, two3, three, one1</code>unSorted input:<code>select regexp_replace( 'three0, thr...
20 hours ago3.1 years ago

Hi Tom,in our ETL tool we have a process by which a flat file is read and transformed. A table is created with columns to hold the flat file content and columns for the functions that are applied sequentially per row. the file content is loaded via bulk copy. ...
42 hours ago6 days ago

Hi Tom,How would you recommend generating PDF documents from within "plain" PL/SQL?Thank you,Dieter...
43 hours ago12.3 years ago

Greetings,I have a few questions regarding how Oracle by default encrypts the password when sent to the Oracle databases. (https://asktom.oracle.com/pls/apex/asktom.search?tag=password-security-during-logins&p_session=117601880297172)First, please confirm tha...
2 days ago6 days ago

Hi,I am facing the below exception - ORA-02070: database does not support in this contextHere is the query I am using -INSERT INTO table_1(a,b,c)SELECTtable_name, partition_name, subpartition_name FROM user_subpartitions;Table_1 is in Database_AUSER_SUBPARTI...
2 days ago4.4 years ago

what is the use of "TEMP_UNDO_ENABLED" in oracle database. when our user also use global temporary table.When it's necessary to set TEMP_UNDO_ENABLED = TRUE in which circumtance?If I enable this parameter to true so it's decrese the performance of database ?...
2 days ago2.3 years ago

I want to load a jar file into the database. First I loaded it into the root container.loadjava -o -f -noverify -synonym -stdout -verbose -recursivejars -resolve -grant PUBLIC -user sys/password@CDB javax.mail.jar >\mail.logThis also works, but I don't have ac...
2 days ago6 days ago

Hello Ask-Tom-Team,I came across this Oracle documentation „Deploying Oracle RAC on Docker“:https://www.oracle.com/technetwork/database/options/clustering/rac-ondocker-bp-wp-5458685.pdfSpecifically the sentence:OracleRAC on Docker supports the <b>non-privilege...
2 days ago6 days ago

We need to code a function to convert database server sysdate to GMT date. So we use: alter database set time_zone='EST' to set dbtimezone, and then code something like:CREATE OR REPLACE FUNCTION FN_GET_GMT_DATE RETURN DATEIS v_dbtimezone varchar2(10);BEGIN ...
5 days ago19 years ago

We are upgrading Apex from 5.2 to 20.2. Our applications are using theme 26. (Of course we need to update the applications to theme 42, but for now this step is too big.)After the upgrade, the prompt of the region buttons is shifted to left (behind the buttons...
6 days ago6 days ago

In some of my custoner´s databases the DBAs are using AUTOEXTENSIBLE datafiles, but with many datafiles comparting the same filesystem, in this sense : tablespace A, datafiles /u01/oradata/ts_A_file01.dbf autoextend unlimited tablespace B, datafiles /u01/ora...
6 days ago8.8 years ago

I am in the process of implementing a process in APEX. This process includes some roles. The process is initiated by a person who fills in forms in the first step.The data entered is stored in collections and entered into the corresponding tables after submiss...
6 days ago2 weeks ago

Hi Tom,we're making plans to migrate from basicfile to securefile lob storage (Oracle Database 19c). The database also contains some spatial layers, in partitioned tables with a local spatial index. These tables/partitions were defined in Oracle 11 without exp...
7 days ago2 weeks ago

Hi!We would appreciate your advice about problem we have.We have two tables of the same structure in different DB (DB1 and DB2) . Rows are inserted into table in DB1, and then some of them (based on simple condition) are being prorogated to the table in DB2 ...
7 days ago2 weeks ago

Hello everyoneAt first, I have an angular UI client and ORDS as API.I'm going to use RAS(real application security) or VPD for row-level security. I read oracle RAS documentation and I didn't catch how to use it with ORDS(without apex) and this is true for us...
7 days ago5 weeks ago