Questions

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

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

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

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

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

Hi There,all the recent news about APEX AI Assistance for code generation ? doe sit comes out of the box ? or we need to configure and pay to AI/LLM provider like ChatGPT ?I am referring to your recent video Build AI-Powered Enterprise Apps Faster with Oracle ...

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

Hello TOM,Is there a way to perform a accent-insensitive conversion ONLY?I'm using the construct:<code>SELECT utl_raw.cast_to_varchar2(NLSSORT('ABCöüä', 'nls_sort=binary_ai')) FROM dual;</code>which - as byproduct - is performing also a case-insensitive replac...

Hi Gurus,I have below query, as you can see, below query read table T twice. just wondering if it is possible re-write it without join. <code>WITH T AS (SELECT 'AAA' STR, 'JOIN' NAME, 1 ID FROM DUALUNION ALLSELECT 'BBB' STR, 'KELLY' NAME, 1 ID FROM DUALUNION A...

I am trying to move data between two partitioned tables. Below is the sample script. I am working on Oracle 19c and using 12c feature of creating table for exchange. Please suggest what is missing.How can i move partitions between two partitioned tables. This ...

I'm trying to create a generic before update trigger which will compare all :old.column_values to all :new.column_values. If the column_values are different, then I would like to log the change to a separate table. When I try to compile :old.<column_variable...

Hi Tom , We have to load some data in oracle from a flat file . The date in flat file is displayed in Julian date format so 31st Mar 2003 comes as 2003090(number of days since Jan 1st,2003) and 20th Mar 2003 comes as 2003069(again number of days since...

Hi Tom,Need your kind help to check and advise. i need to find number of hours employee worked between 10:00 PM to next day 06:00 AM between two days.Ex: 1. employee work schedule is 11-MAY-2012 16:00:00 to 12-MAY-2012 09:00:00 Ans: Night hours would be 8 hour...

How to connect oracle database / data set into Power BI, I already searched from google and youtube but I can't do it please help.Thank you....

Is there any SQL construct that does fuzzy matching ?As an example , if I have the values as Monroe , Monroe Twp , Monroe Township , "Monroe Twp,NJ" , I would like to consider them as one value . ...

Dear AskTom Team,I'm getting crazy wondering why a query with a FIXED baseline runs only sometimes with plan fixed by the baseline.<code>SQL_HANDLE LAST_EXEC FIX REP CREATED------------------------------ -------- --- --- --------SQL_1a03d3b...

I've installed Microsoft's ODBC driver and configured various files in an attempt to create an ODBC connection from my Oracle database to SQL server, but I'm having trouble connecting from SQL Developer. Using the terminal, I can connect to the SQL Server succ...

Hello, I am trying to figure out why this answer is correct regarding a LONG data type.Here is the questionEMP_DETAILS table<code>Name NULL TYPEEMP_ID NOT NULL NUMBEREMP_NAME NOT NULL VARCHAR2(40)EMP_IMAGE LONG</code>...

Hi Chirs/Connor,Couple of question related to Table data movement from Primary DB to Archival DB.We are having Two DB's - Primary (holding current 2 years of data) Archival (Primary data + historical)We have separate Archival DB using IMP/EXP from Primar...

I have a huge partitioned table(about 3TB) that has a constraint(PK) in "enable novalidate" state.I have to alter the state to "enable validate" state.<code>alter table TEST enable validate constraint PK_TEST;</code>The table belongs to the database(exa) in pr...