Skip to Main Content

Questions

QuestionUpdatedAsked

Hello Tom,I have a table with a CLOB column:<code>create table plch_clob(i int primary key, x clob);begin for indx in 1 .. 1000 loop insert into plch_clob( i, x) values (indx, 'CLOB Row: ' || indx); end loop; commit;end;</code>By calling the func...
5 hours ago8 years 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...
5 hours ago3 years ago

"alter session sync with primary"raises ORA-03173 for us.<code>SQL> select database_role, open_mode, db_unique_name from v$database;DATABASE_ROLE OPEN_MODE DB_UNIQUE_NAME---------------- -------------------- ------------------------------PHYSICAL...
6 hours ago5 days ago

Hi, I have a table contains 50+ million records, and I am writing a procedure to replace the bad data to the correct values(about 1500 records). <i><b>K_V</b></i> is the array of bad data and target correct value,like <code>K_V('bad data1') := 'correct value...
26 hours ago8.1 years ago

Hello masters. Here I am again with another mystery from our favorite DBMS (no, that was not sarcasm, I do love Oracle in fact).So, in my company we are facing the referred error, ORA-12569: TNS:Packet Checksum Failure While Trying To Connect Through Client. ...
26 hours ago5 weeks ago

Hi!I have a problem with <b>downloading XLIFF file</b> for whole application (Shared Components\Translate\XLIFF Export). It looks the request timeouts after 5 minutes ("Failed to load resource: the server responded with a status of 500 (Internal Server Error)"...
26 hours ago2.1 years ago

I query table 'user_segments'sql>select segment_name, segment_type, tablespace_name, bytes, max_extentsfrom user_segmentswhere segment_type like 'LOB%'result isSEGMENT_NAME SEGMENT_TYPE TABLESPACE_NAMESYS_IL0000012099C00002$$ LOBINDEX ...
26 hours ago22.3 years ago

Apologies if my JSON terminology is not quite accurate, but hopefully the test case shows the issue. We are in the process of upgrading DBs for a legacy in house application from 12.1.0.2 to 19.18. We noticed during testing that when we are selecting sets of n...
26 hours ago10 months ago

UserI HAVE SUCCESSFULLY RUNNED A JOB WHICH HAS STORED PROCEDURE OF TRUNCATE AND INSERT STATEMENTS USING DBLINK, IF ERROR OCCURS, ROLLBACK STAEMENTS ALSO THERE IN ORACLE PLSQL. WHILE DOING SO, TRUNCATED DONE AND DBLINK COMMUNICATION INTERUPPTED AND GOT END. SO,...
26 hours ago7 days ago

Hi Tom,I have a some questions regarding the capacity planning.Thanks in advance.1.is there any way we can match LIOs & PIOs to the no of CPUs & no of disks ?2.is there any place , i can find documents to do capacity planning for the oracle database/sun solari...
2 days ago20.2 years ago

I need to have current cursor position in TinyMCE Oracle Apex. I use this js code for another type of page items and it work correctly.var curPos = document.getElementById("P7_TEXT").selectionStart;but when "P7_TEXT" is a Rich Text Editor (TinyMCE) , it will r...
2 days ago5 weeks ago

Hi TOM i have oracle cluster database EE with 2 nodes, and i have a big table with a big LOBs row, so after compressing the LOBs files i did move them to a new tablespace,so the principal table became just about 300MB but it still taking space of 1.2Tb, my con...
2 days ago5 weeks ago

HelloWe want to housekeep our user accounts and remove unsed and locked accounts. As far as I understand, the information in dba_users is from the primary DB. Users are not allowed to logon to the primary to query data, they must logon the read only standby (r...
2 days ago5 weeks ago

Views with group by grouping sets and pivot directly or in referenced view which worjk in Oracle 12c fall with ORA-56903 error sys_op_pivot function is not allowed here in Oracle 19. Bit in view or referenced view don't have explicit call sys_op_pivot. Mybe Or...
2 days ago4 weeks ago

Please advise on why in Oracle 19c (19.16) trying to refresh a non-existent materialized view results in error ORA-01031: insufficient privileges instead of ORA-23401: materialized view does not exist.<code>begin dbms_mview.refresh('scott.nonExistentViewHere...
3 days ago1 years ago

Dear Team,I hope this message finds you well. I have been reflecting on the current landscape of PL/SQL and its role in contemporary technology stacks. I would greatly appreciate your insights on a few points that have been on my mind.<b>PLSQL for Business Log...
3 days ago4 weeks ago

I created a text file on oracle database server.The name of the file is 'TestFile' and it is located in C:\TestFolder\TestFile.txt .All C drive and 'TestFolder' folder and 'TestFile.txt' file have full control permission for everyone OS users.I create a direct...
3 days ago5 days ago

Hi AllIt's my first question here :)I read about formatting number in scientific notation, but I don't find a way to group exponent by 3For instance, I would have this result Number -> result1 -> 001.0E012 -> 012.0E0123 ...
3 days ago7 days ago

Dear Tom,As User System connected I want to query a V$ table in a view. When creating the view I get the error ORA-00942: table or view does not exist.Example:<code>create or replace view myview_datafile as select file#, bytes/1024/1024||' MB' as "SIZE" from V...
3 days ago7 days ago

Is Oracle working on the Oracle Database PL/SQL package UTL_HTTP to add support for http_versions: HTTP/2 and HTTP/3?...
3 days ago7 weeks ago