Skip to Main Content

Questions

QuestionUpdatedAsked

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 ...
22 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...
43 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? ...
2 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...
2 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...
2 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 ago7 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

we see this error in the daily full=Y backup :Processing object type DATABASE_EXPORT/SCHEMA/PROCACT_SCHEMAORA-39127: unexpected error from call to TAG: SCHEDULER Calling: SYS.DBMS_SCHED_CLASS_EXPORT.GRANT_EXP obj: SYS.IDX_RB$CLASS_54724 - SCHEDULER CLASS ORA-0...
2 weeks ago2 weeks ago