V$PDBS

How to Resolve ORA-16000: database or pluggable database open for read-only access

by Ed Chen
December 6, 2022December 24, 2022

ORA-16000 Tried to update some rows, but it failed with ORA-16000. SQL> update employees set first_name = 'Ed' where last_name = 'Chen'; update employees set… Read More »

How to Check Database Creation Date

by Ed Chen
June 21, 2021April 15, 2023

Database Creation Date A simple way that can check the creation date of a database. When the data is running, no matter the instance is… Read More »

How to Resolve ORA-01516 Error Message

by Ed Chen
June 24, 2017March 14, 2023

ORA-01516: nonexistent log file, datafile, or temporary file There're two scenarios that throw ORA-01516 going to be introduced in this post. 1. Rename Tempfile I… Read More »

JavaScript is not enabled. Please enable it and reload the page.