Skip to Main Content

Ask The Oracle Mentors

Recently Answered

Recently Answered Report

Chris SaxonHow to export data for specific time period using DBMS_DATAPUMP api.
We have a requirement where we are looking for DB dumps to be exported using DBMS_DATAPUMP api for specific time period like 01-Jan-2020 to 31-March-2020. I am aware of Flashback time and flashback scn number but it will export only for specific timestamp but ...
Chris SaxonOracle Pivot table
I have a Oracle pivot query that works with 19 values in the IN clause but when I add a 20th, it fails with an ORA-01427 error. This works:<code>select * from (select serial_no, buyoff_user || chr(13) || to_char(buyoff_date) || chr(13) || serial_oper_status ||...
Chris SaxonFetching last record from a table
I was wondering if there is some possible way that I can fetch the last record from a table. In this particular case, obviously one is unaware of the number of records in a table. All I want is to write a query whcih will simply fetch all the columns of the la...
Chris Saxoncycle detected in recursive query where it seems to be no cycle
I have recursive query on Oracle 11g table with undirected graph data. Each row represents one edge. The recursive query traverses all edges starting from given input edge. The idea of query is: - input edge is at the 0th level- for n>0, edge is on n-th level ...
Connor McDonaldFAST RECOVERY AREA best practice and not recommend
Greetings,My question involves the use of the FAST RECOVERY AREA for online redo logs and even controlfiles. Typically, the backup mount points are on slower disks. Therefore, if we were to set DB_RECOVERY_FILE_DEST to that backup mount, my assumption is tha...