Questions

I am normally using "<code>SELECT DBMS_METADATA.GET_DDL('USER', 'User_Name') FROM DUAL;</code>" to get the hashed password ( which I use to re-create the user as it was ), with SYSTEM user.This unfortunately does not work for users which have password_versions...

Hello,I have a question regarding concurrent statistics gathering in Oracle 19c. Currently, my global preference is set to OFF:SELECT DBMS_STATS.GET_PREFS('CONCURRENT') FROM DUAL;-- Result: OFFI can enable it manually with:BEGIN DBMS_STATS.SET_GLOBAL_PREFS('C...

All,I have an Oracle view built on top of a partitioned table. Occasionally the view becomes INVALID, even though there are no DDL changes happening on the base table. The view becomes VALID again automatically when it is accessed or queried, but this behavior...

is Instances can exist without the database and database can exist without instance...

Hello Connor/Chris,Hope you are doing well.Recently, I came to know about the PART_NAME parameter for multiple APIs of DBMS_REDEFINITION package from the documentation. However, I could not find much about what kind of changes are permitted (and prevented) at ...

Hello i just wanted to ask you a question. Can you please provide me some good online oracle books, tutorials or courses of the dba technologies like RMAN, Golden Gates, Exadata, Data Guard, Data pump and RAC? thanks....

Well hello i just wanted to ask you when you have 100000000 rows of data and the best partitioning strategy is to use partition by range with subpartition by hash (having a column that is date type called hired and in the range we have YEAR(hired) and in the h...

Hi Tom,I was learning Secure Application Roles and created an example to test it. Everything worked fine to actually create and enable the role, but I'm getting an error disabling the role (actively disabling it, not just letting the end of session do it).Fir...

Hi,As part of capacity planning, customer is asking schema table size growth per year for last 10 years. Is there any way to get it?I tried the below query but through this we are not able to get size per year for last 10 years.SELECT ds.tablespace_name,ds.seg...

Well hello i just wanted to ask you a question. Before 1.5 years i installed 23ai version and i downloaded sql developer. Before 1 month i opened my sql developer and i saw that my hr user is locked so i had to connect to sys user and then i pressed the follow...

Hello,We have a Java process that calls OR stored procedure via JPA. This procedure was initially declared outside of a package, and everything worked fine, but when we moved it into a package, we encountered date conversion problems related to the incorrectly...

We don't seem to be able memoptimize a table for read when there are triggers on it (this seems to be undocumented however ?).But: we can add the triggers later on without problem and the table continues to be memoptimized for read.Question: WHY ? Is it a bug ...

Hi all,I have a hierarchy between levels in my_hierarchy table (between id_lvl and id_lvl_sup).Each level (lvl) may have items (id_item), and each item has a category (id_item_sup). These data is stored in my_items table.Now I want to build a report based on t...

<b>My goal</b> is to create a fast refreshable materialized view (MV) that holds all the combinations of records in specific related tables. So also the 'incomplete combinations'. So the query that is needed contains a full outer join.<b>First a disclaimer abo...

I’m using a Polymorphic Table Function (PTF) and adding a new column TIMESTAMP_CALCULATED of type TIMESTAMP with fractional seconds scale 9. In FETCH_ROWS I populate it with a constant value:2026-01-01 01:01:01.123456789However, when selecting the PTF output, ...

Hi Tom,I got a Web Form that is able to display data to users and read user input back into the database. It is very important to be able to read user input back into the database. This is why I did not use out-of-the-box solutions like "owa_utils.read SQL int...

I would like to be able to analyze large PL/SQL code base to identify internal PL/SQL subprograms called in PL/SQL application code.I know that I can get package level dependencies with DBA_DEPENDENCIES and that PL/Scope should give subprograms level informati...

Hi TomHow do I confirm that the following event has been set:SQL>alter system set events '12899 trace name errorstack level 3';?ORA-12899 has occured after the event was set but no trace file is found in the udump catalog. The event was not set by me and I am...

HI TOM,Tnx for this oppurtunity again, Can You explain how does the ORA-4068 occurs and how can I go about it? How does oracle manages the freelist (8i) on LMT's? And how can we track the freespace, used space, and fragmentation on LMT's?What's the difference ...

Hi,I have created an application that is tracking a set of processes that are being run from a master table. When a process is completed, a flag in a column name PROC_EXEC_STATUS changes from N to Y for each process. I want my oracle apex application to refres...