Questions

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

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

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