Skip to Main Content

Questions

QuestionUpdatedAsked

HI,I need to perform fulltext searches in an xmltype XML field. The table in which this field is located has other fields that can be used to narrow the search in the fulltext index (for example, a date field). However, I noticed that by creating a composite d...
2 hours ago3 days ago

Hi Tom,I need to come up with an automated method to insert data (xml_type) from an external flat file into to a table in Oracle Database using SQL Developer.Read some articles which shows how to load the files by using a control file, but I couldn't find any ...
24 hours ago9 days ago

Hey Tom, 1. I would like to know the factors influencing the rollback speed of a transaction. And why does it generally take more than the time it took for the actual transaction. Could you show some light on this?2. I read one of your answers where you have s...
45 hours ago3 days ago

Can the shared_pool_size and the streams_pool_size parameters be set to the same value?Both parameters are currently set to zero. I would like to set them both to 2g. I will need to use about 1.5g of the streams_pool memory for Golden Gate. Will this work? ...
3 days ago9 days ago

Hi,Due to my work environment, I'm not allowed to cut and paste from my environment. As a result of that I cannot provide a specific test case, but just gives symptoms, would you give me general guidance on how to approach this problem?I'm running a huge inser...
3 days ago10 days ago

We perform a duplicate database from prod to test weekly and have a script that captures the current user permissions on dev via the dbms.metadata.get_ddl package that generates DDL to another file to be used after the duplication to re-create any user that ha...
3 days ago6.5 years ago

Tom-- I subscribe to your SQL mantra for data (and truly, is there anything else? :)) which is:1. Do it in a single SQL statement if at all possible.2. If you cannot, then do it in PL/SQL (as little PL/SQL as possible!).3. If you cannot do it in PL/SQL, try a ...
3 days ago18.8 years ago

Hi Tom , I have your book and am still not able to understand the mechanism of hash join . it just says similar to this ( I do not have book at work so can not exactly reproduce it )one table would be hashed into memory and then the other table would be used t...
3 days ago18.1 years ago

Hi,What are the best practices to develop CRUD/DML APIs (using packages or subprograms) in Oracle. If i want to insert, read, update or delete data, i want to do it through APIs. Furthermore, what can be the possible cons of using APIs instead of using normal ...
6 days ago8 days ago

Hi!We have a lot of Apex apps, so we check the LAST_UPDATED_ON value in both the production and dev apps before deploying to production.Like this:<code>select d.APPLICATION_ID, d.APPLICATION_NAME, d.ALIAS, d.OWNER DEV_OWNER, p.OWNER PERP01_OWNER, d.LAST_UPDATE...
6 days ago9 days ago

Hello. I have an application in which users upload PDFs to a table. How can I check in PL/SQL if a PDF in a blob is digitally signed?Ideally I'd like to know if the signature is valid, but just knowing if a file is not signed would be enough to reject it and s...
8 days ago9 days ago

hello , i have a table TDRCORE.FCM_CCBF , PARTITION BY RANGE (RQO_PROC_UTC_DATETIME TIMESTAMP(6))INTERVAL( NUMTODSINTERVAL(7, 'DAY')) tehre is an SQL running on LIVE db that comtains many unions but i will not post full script , i will post just 1 part of th...
8 days ago9 days ago

I understand how to use the online pragma before the invocation of a subprogram that should be inline, but based on the Oracle documentation (https://docs.oracle.com/en/database/oracle/oracle-database/19/lnpls/plsql-optimization-and-tuning.html#GUID-2E78813E-C...
2 weeks ago2 months ago

Description of getDatabaseMetadata()["COLUMN_SIZE"] in Javadoc:"The COLUMN_SIZE column specifies the column size for the given column.For character data, this is the ***<b>length in characters</b>***."Scenario:- Check that database encoding is multiple bytes p...
2 weeks ago9 months ago

Hi,I am trying to restore target database with below command :rman auxiliary /run {allocate auxiliary channel ch1 type disk;allocate auxiliary channel ch2 type disk;allocate auxiliary channel ch3 type disk;allocate auxiliary channel ch4 type disk;allocate auxi...
2 weeks ago7.9 years ago

1) I am using oracle xe 21c database, apex 24.1 and deployed on tomcat 9.0.90 on my labtop2) I try to connect my office server using Rest enabled sql service. Where I rest enabled entire schema3) On my labtop when I try to connect it giving me error : The URL ...
2 weeks ago3 weeks ago

Could you please kindly check and advise on the following. i need to find break hours between two dates. and also i need to find if this break mins is within night hours (10PM to 6AM next day).ex: employee work schedule 11-MAY-2012 16:00:00 and 12-MAY-2012 09:...
2 weeks ago4 weeks ago

Hi,In order to improve reading performance of a LOB column in my table, I enable CACHE option for it.But when I check in the buffer cache using gv$bh (I did some SELECT queries on it so it can be cached), I cannot find any entries for my cached LOB.<code>SELEC...
2 weeks ago3 weeks ago

Hi Tom,I have a requirement to update/Delete(permanent) the archived(Data deleted. But present in flashback archive) data.Can we update/delete(permanently) a record/set of records present in flashback archive?...
2 weeks ago7.1 years ago

our Daily job expdp has full=yes and worked OK till last night.last night the expdp log showed:ORA-31693: Table data object "AUDSYS"."AUD$UNIFIED":"SYS_P23021" failed to load/unload and is being skipped due to error:ORA-02354: error in exporting/importing dat...
2 weeks ago3 weeks ago