Skip to Main Content
Ask The Oracle Mentors
Ask a Question
Recently Answered Report
How 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 ...
Oracle 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 ||...
Fetching 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...
cycle 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 ...
FAST 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...
Upcoming Office Hours
All Office Hours
Free training, how-tos and Q&A with Oracle experts, every month!
Weekly Office Hours: OML on...
Starts in 5 hours
JSON Workshop with Jeff Smith
Starts in 7 hours
Starts in 8 hours
Back to basics with Transpa...
Next: March 10 15:00 UTC