Skip to Main Content

Questions

QuestionUpdatedAsked

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...
2 days ago3 days ago

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...
2 days ago2 days ago

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...
2 days ago4 days ago

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 ...
2 days ago3 days ago

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...
2 days ago2 days ago

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...
2 days ago2 days ago

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...
2 days ago3 days ago

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

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 ...
4 days ago8 days ago

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 ...
4 days ago2.2 years ago

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...
4 days ago2 weeks ago

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 ...
4 days ago19.4 years ago

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...
5 days ago8 days ago

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....
6 days ago9 days ago

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...
6 days ago9 days ago

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...
6 days ago4.9 years ago

I need to give access to other user on current DB_LINK, can you provide command ?Current Link: sittestGrant to User: Z9XBIQ1_DWRegardsChaudhry...
6 days ago4.8 years ago

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...
8 days ago9 days ago

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....
9 days ago9 days ago

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 ...
10 days ago5 weeks ago