Some times an aleatory select statement stop working without a clear reason.Some times the statement is inside procedure, some times it is executed directly from ODAC FOR .NET 4Then only thing in common it was always executed by ODAC client, so I never got thi... | 5 days ago | 12 days ago |
We have looked at dbms_flashback and dbms_wm but both don't deliver what we actually want: Is there a possibility to make an entire session transient?We would like to use this for our testing scenario's:1. Start the session in "transient mode"2. execute ... | 5 days ago | 7 days ago |
Hi Connor, Chris,I have a FOR UPDATE SQL used to lock certain rows in ORDERS table but it seems to be bit slow (takes around 1 min).I tried getting plan from dbms_xplan.display_awr. Could you please give me some lead from your past experience and I can look fo... | 5 days ago | 7 days ago |
I do have a question about Oracle Indatabase archiving in Oracle 19c,given below table has a XMLtype columnalter table HTS_SUMMARY_DATA_CELL row archivalError report -SQL Error: ORA-38353: This table type is not supported by the ROW ARCHIVAL clause.This error ... | 5 days ago | 11 days ago |
I have a simple stored procedure, that I would like to have a passed in string(varchar2) for used in select from where col1 in (var1) in a stored procedure. I've tried everything but doesn't work. Followed is my proc. Thanks CREATE OR REPLACE PROCEDURE WSRE... | 5 days ago | 20.5 years ago |
The server machine on which the DB resides has 32 CPUs. (2 sockets * 8 cores per socket * 2 threads per core)I notice many oracle processes (both non-background and background) consuming high (sometimes 100%) of the CPU.Now, this CPU % is only for 1 CPU out o... | 5 days ago | 7 days ago |
Hi Chirs, Connor,Could you please help or suggest a way to generate string based on patternPattern - <b>^[a-f0-9]{8}-[a-f0-9]{4}-[a-f0-9]{4}-[89ab][a-f0-9]{3}-[a-f0-9]{12}$</b>I need to generate millions of string like <b>f9f8c8e2-0b20-4160-8f74-e836f4661fc5<... | 6 days ago | 7 days ago |
I want to return headers of column along with data while returning result using refcursor.<code>create table fetch_header_rows(company_name varchar2(500),Company_id number,ammount number(20,8),data_commnets varchar2(500));insert into fetch_header_rows values('... | 6 days ago | 7 days ago |
Purchase_Mas contains data of purchase master and payment_amt contains data of payment received from party.Cursor c2 does not return any value when not found in payment but still i want to some calculation happen even data not found in payment table.run follow... | 6 days ago | 7 days ago |
Hi TeamWe are running Non-RAC Oracle 11.2.0.3.0 and the TNS poison attack vulnerability (Oracle Security Alert for CVE-2012-1675 - https://www.oracle.com/security-alerts/alert-cve-2012-1675.html) looks affected this version of Oracle.What we have done:* Have a... | 7 days ago | 7 days ago |
Hi,In my procedure I'm trying to check whether a database link and a directory exist. If they don't I wanted to display a nice message about them needing to be created etc.I thought of using dbms_assert.sql_object_name, this seems to do the trick for tables, v... | 7 days ago | 3 weeks ago |
Hi,i want to iterate all rows in table and do some operations on them, but i don't want to get data with some select statement. In order to do that i tried to export data as .dbf and read it with Java and do some stuff. But it seems Oracle .dbf format differs ... | 7 days ago | 12 days ago |
Hello Tom,Please, I need a big help.I have a job scheduled in Enterprise Manager 12c. This job do a full export, but two days ago I started to get the error below:ERROR at line 1:ORA-31626: job does not existORA-06512: at "SYS.DBMS_SYS_ERROR", line 79ORA-06512... | 7 days ago | 3.8 years ago |
Greetings,How can we make our bi-yearly password update of accounts used by hundreds of application servers as easy as possible? Running the "alter user <username> identified by <newpassword" is easy. The hard part is updating and encrypting the new password... | 7 days ago | 2 weeks ago |
I've a requirement to convert hardocdings in below case statement used in sql to a lookup reference table .The case statement refers to 4 columns i.e enterprise,pbm_vendor,bhc_relationship_type,payer_entityI would like to create a lookup table using these 4 co... | 7 days ago | 13 days ago |
I want to insert data from excel or csv file (Id, Name, Address, Amount) into database table by using data load but during the insert of this data i want to decide this data is related to HSBC Bank (Because i have many bank and each bank have thousand of custo... | 10 days ago | 13 days ago |
Hello,Is it possible to write a single SQL query that would concatenate multiple rows into a single row with multiple columns?For example, I have a table with the following data:<code>TYPE DATE AMOUNT--------------------------------B 30.6.2019 ... | 10 days ago | 9 months ago |
Hello Tom, How to do a Full DB exp and Import.I do say exp system/manager@xyz FULL=Y FILE=FULL.DMPThen If I want to do a full Import to a new freshly created DB which only has the default schemas sys , system , etc.1) Please correct me :- I would n... | 11 days ago | 11.7 years ago |
I have a table with two columns that need to be defined as primary keys, order_number and item_number. A table can have only one primary key, but I can define composite primary keys in the table_constraint syntax. How do I define two columns as composite pri... | 11 days ago | 20.5 years ago |
I have inserted the same primary key data but the Second Session is locking forever! Is there an option to alter user session to raise timeout after 60seconds or NOWAIT for the second sessions INSERT command.In our environment session 1 is a long running batch... | 11 days ago | 1.6 years ago |