(Connor McDonald) As always, you should read the Installation/Upgrade manual from top to bottom before upgrading any piece of software, and be aware of all of the pre-requisites and processes.
Tag: Oracle
Adding a Tablespace to a PUM
(skp) Somehow I misplaced or mistyped the SYS password on the last PUM install that I did. I learned a few things as a result…
Unindexed Foreign Keys in Oracle and PostgreSQL
(Franck Pachot) In Oracle we need to have a index on the foreign key column as soon as we have the intention to delete from the parent row, or a locking situation may block all transactions around the child table.
Recreate Database Using Only Datafile and Logfile
(Anuradha Mudgal) Let’s have look on the steps are used by Oracle DBA for “Recreate Database Using Only Datafile and Logfile”.
Oracle Offline Persistence Toolkit – After Request Sync Listener
(Andrejus Baranovskis) In my previous post, we learned how to handle replay conflict – Oracle Offline Persistence Toolkit – Reacting to Replay Conflict.
Manage common and local objects in application containers
(Jagruti Jasleniya) Oracle databases are always extremely advanced and sophisticated software components that are state of the art for RDBMS.
Efficiently query DBA_EXTENTS for FILE_ID / BLOCK_ID
(Franck Pachot) Did you ever try to query DBA_EXTENTS on a very large database with LMT tablespaces? I had to, in the past, in order to find which segment a corrupt block belonged to.
Oracle Forms to APEX IDE Transition
(Scott Wesley) If you would like a good high level run-down on why Oracle APEX is a great choice to modernise Oracle Forms, have a read of this.
Backup CDB and PDBs
(Jagruti Jasleniya) Oracle databases are always extremely advanced and sophisticated software components that are state of the art for RDBMS.
ORDS 18.3: X-ORDS-FORWARD and :BODY_TEXT
(Jeff Smith) The forwarding bit isn’t a new feature, but we have introduced new ORDS response header variables in version 18.3 of ORDS.
