Questions

HelloI'm using SQL Dev 20.2 and since I've upgraded from 17.2, I'm having issues exporting to Excel any data that has a Clob field in it. The data gets extracted and shows on SQL Developer okay but when I export it to Excel it creates an empty 4KB file. Work...

I have the script below that was working normally, however, I believe, that the gmail certificate has expired.With OpenSSL> s_client -connect smtp.gmail.com/1687 -starttls smtp, I generated another certificate for my wallet and updated the ACLs, but still it s...

Hello team, we are planning to clone a two nodes RAC database on ASM to a test database on one server only. The test server has grid and Oracle database software installed and ASM diskgroups configured. After RMAN duplicate from active database with cluster_d...

In the Example of Multiple Recipients in the https://oracle-base.com/articles/misc/email-from-oracle-plsql#multiple-recipients link, mail goes to all the recipients. But, all the names in the "To" list is available to all the recipients.Is there any parameter ...

Hi, When using the legacy IMP tool, if you have specified ignore=y commit=y and buffer=9999999 what is the behavior of IMP when a unique constraint is violated by a row in the buffer?Assuming the buffer holds more than one row, will IMP reject the entire buffe...

SQL Developer extract to Excel - Date Format is changing from 02-NOV-2020 12:00:00 AM to 11/2/20 Hi I'm using SQL Developer 20.4 and Excel 365 16.0.13127.21490.When I run a SQL with dates, the dates are delivered in the format of 02-NOV-2020 12:00:00 AM. When...

i have a Solarias OEM installation, we use DBs across differents platforms90% on Solaris and 10% on Linuxhoe can i install the linux agent whitout install all the OEM on linuxand how to load this Linux agent on Solaris OEM...

Hello experts ,Is it possible to restore entreprise edition rman backup which contains partitionned tables to a Standard edition instance?Thanks in advance. RegardsNabil....

Greetings,I have this extremely perplexing situation where Oracle changes how it records a block read. Last week it wasn't COUNTING block reads at all in an I/O wait event; this week it started to add it to the “direct read” wait event. This is occurring in ...

Hi TOM,I am having a data movement activity from one table to another table.Due to Huge data size in both tables, i have planned to use DBMS_PARALLEL_EXECUTE functionality, so that i can finish it quickly. I am creating chunks based on ROWID.But the challenge ...

Hi Tom,I am given the "current" allocation of items to eight buckets, and I want to make it more efficient by filling as much as possible of bucket A, then of bucket B, then of bucket C (as indicated by the "priority"), by moving items between buckets by takin...

Tom: We have a 6 millons rows table and we need to clean it. This process will delete 1,5 millons.My first approach was create a SP with this lines: SET TRANSACTION USE ROLLBACK SEGMENT Rbig; DELETE FROM CTDNOV WHERE CTDEVT IN (4,15); (1,5m rows) COMMIT;Then ...

I have 2 pairs of parent and child tables ,1 pair is stored in a clustered object and the other is non-clustered. The primary key of the master table (which is foreign key) in the child table is clustered. An index on cluster is also created.The structure of 2...

with this normal query of deletedelete from table where condition-'a'; will it work in table data are present from year 2014.i want to delete all data starting from 2014 to till now....

HiI have tried 19.9 - 19.11I have noticed some suspicious behaviour regarding dual.I will create an example. At the moment, here you can see that from mytab, there comes only single row.Then I will dump the datatype to output.<code>SQL> set serveroutput on siz...

Hello,We have a requirement to add a new column in the table which needs a default value like column1 || column2.For some reason application code can not be changed to deal with this new column and so the default value.I thought of two approaches that can solv...

I need to give access to other user on current DB_LINK, can you provide command ?Current Link: sittestGrant to User: Z9XBIQ1_DWRegardsChaudhry...

Hello Team,First of all, thanks for all the good work you are doing.Request your help with a query related to re-sequencing of table columns using invisible columns. Is it safe to change order of columns in a production environment, following the method descri...

We have a requirement where we are generating .csv file from DB and placed it to a DB directory. We want to zip these .csv files so that size can be optimised. Could you please suggest a way to achieve it by using PL/SQL....

Hi!We would appreciate your advice about problem we have.We have two tables of the same structure in different DB (DB1 and DB2) . Rows are inserted into table in DB1, and then some of them (based on simple condition) are being prorogated to the table in DB2 ...