(David Fitzjarrell) A recent question in the Oracle database forums has a user wanting to open his physical standby database in READ WRITE mode but still keep it as a physical standby.
Tag: Oracle
Copying a Tablespace from NonCDB to a PDB (using TTS)
(Hemant K Chitale) A Tablespace can be “transported” from a NonCDB to a PDB as a way of copying the Tablespace. Here I work with ASM as well.
Executing Queries from the Application
(amitzil) Databases are designed to hold data and retrieve it, so they are optimized to run queries. Over the years I’ve seen quite a few cases where the developers did things on the application side that could be easily done on the database side, and almost every time moving it to the database impr
Performing a large correlated update
(connormcdonald) We had a question on AskTom recently asking for the best way to update a new column on a very large table. Four in-place update options are at our disposal:
Redo a blogpost
(Frits Hoogland) This blogpost is about the Oracle redo log structures and redo efficiency in modern Oracle databases. Actually, a lot of subtle things changed surrounding redo (starting from Oracle 10 actually) which have gone fairly unnoticed.
SQLcl as a library in existing programs
(Kris Rice) I got a question over the weekend if SQLcl could be leveraged as library from inside a Jython program. This may seem like it’s the same thing as adding jython to SQLcl to use instead of Javascript but it’s a significant difference.
‘If You Change This, Right Here …’
(David Fitzjarrell) It isn’t unusual for Oracle to expand functionality with each new release; a short list includes AWR, ADDM, the SYSAUX tablespace, Flashback Query, Flashback Database and Edition-based Redefinition.
Oracle TO_DATE Function Explained with Examples
(Ben) The Oracle TO_DATE function is one of the most common and useful string manipulation functions in Oracle, but it can be confusing. I’ll explain how to use the TO_DATE function in this article.
Characterset the email revenge
(Dbaharrison) Now if you’ve read a few of my blog posts over the past few years you’ll know i have an ongoing hate/hate relationship with anything to do with charactersets.
V$RMAN_BACKUP_JOB_DETAILS, a caveat
(Hemant K Chitale) Building on a previous blog post (you could read it before or after this post), here’s a quick demo of a caveat or quirk with V$RMAN_BACKUP_JOB_DETAILS.