Questions

Hi,I used explain plan and got the following results. Based on cost and time, does query 2 perform significantly better than query 1? The runtime for query 1 is approximately 1 minute and 40 seconds, but it shows 07:47:02. Why is the estimated time so differen...

Hi, Tom. Please see below script.<code>create table t0326 (id number, num varchar2(100)); declare v_empno number:=125854437665589038536841445202964995521300;begin dbms_output.put_line('v_empno -- ' || v_empno); dbms_output.put_line('to_char(v_empno) -- '||...

Hello Tom,A colleague of mine is a big fan of service-oriented architectures and middle-ware. His view is that dblinks are 99.9% of the time a bad idea and that you should go via some sort of message layer in order to pass information between applications.In ...

We recently had a database failure that resulted in data loss after an Oracle 19.3.0.0.0 database had both both its control, and redo log files deleted. Please note that I am not a DBA, but simply an analyst that supports the system that sits on this Oracle da...

Is 'SELECT * FROM :TABLE_NAME;' available?...

Hello Sir,I am able to get one scenario to work and that scenario was where I had a VM (server) running Oracle 19c with just 1 table 5 records and I did a backup of the whole VM (disk backup) and now I added a new table in my db with 3 records (ensured db is ...

We have an application that has been written to insert a variable that is char(50) into a column that is defined as char(40). In Oracle 11g (I know this is very old) it would merely truncate the last 10 characters without issue. However, Oracle 19c doesn't a...

According to https://docs.oracle.com/database/121/SQLRF/functions100.htm#SQLRF00658 the length function should work on a clob and on a varchar2, returning the length of a string in characters, as defined by the input character set.Could you explain why the len...

Hello,I wanted to ask about new 23C feature - Schema-level Privileges: is it possible to combine it with "WITH GRANT OPTION"?According to documentation https://docs.oracle.com/en/database/oracle/oracle-database/23/dbseg/configuring-privilege-and-role-authoriza...

Hai all,I have 1000 number of tables. some of the tables got delete rows and updated the fragmentaion is created.How to determine which tables are fragmented ?...

Hi TeamI have below scenario.Step#1) User clicks to particular App UI screen.Step#2) User selects multiple filters on UI - say filter1, filter2 which correspond to table columns.Step#3) For each filter selected by user, he needs to enter data - say Mark (for f...

I am migrating 11g database cross endianness from on-prem to EXACS . On-prem database db_block_size is 4k and all the tablespaces are also of 4k block size . <u>Since, I cannot provision non-standard block size database in OCI</u> , I am worried about the per...

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

Hi,We are trying to compile following class in Oracle database 23c. However, we are encountering surprising error (we are not using ANY database link:Error report -ORA-04054: database link MYOPTIMIUM does not exist04054. 00000 - "database link %s does not exi...

Hi,I know how to use transform=oid:n in a CMD box using impdp. Is there a way to add that parameter to the import when using the Datapump Import Wizard in SQL Developer?Thanks....

Hi Tom,Can you explain, what is 'EDITION' and what is it meant as cross-edition triggers? How it can be useful for high availability.Thanks for you replies. It is a big learning experience....

Hi,What has happened to Tom Kyte's blog http://tkyte.blogspot.com/.Can you add me to white list of that blog ? Will be very great-full.ThanksFahd...

Tom,DBA.DBLINKS - I am confused about what's in DBA_LINKS - I have never used them. I just want to understand what the column definitions mean. They are too vague.OWNER - The user who created the database link. If the link is public, then the user is listed as...

Hello, I am an intermediate SQL and PL/SQL user and I am interested in becoming an Oracle Database Administrator. Could you provide me with a roadmap or step-by-step guide on how to become an Oracle DBA? Additionally, I would appreciate any recommendations on ...

We just hit 2.1 billion row count on a table with primary key INT. This is the worse thing to happen :( Any one know if we can do alter without requiring space on the DB for the entire table?...