ORA-01578 / ORA-01110: data file 1: SYSTEM tablespace got corrupted.
Lost or corrupted SYSTEM tablespace datafile compels every DBA to be on high alert. SCENARIO - 1 : Follow when the below conditions are...
top of page
AnalyzeOra
An Insight into the Oracle Tech
3 min
Datapatch failed because SDO became invalid and PLS-00905: object MDSYS.SDO_UTIL is invalid reported
As I was running DATAPATCH after applying the Jul23 Oracle DB patches, it got failed saying the the SDO component became invalid. Patch...
57 views0 comments
1 min
Jul 23 recommended patches for Oracle Database 19c Enterprise Edition, Release 19.19.0.0.0.
Here is a list of recommended patches for users on Oracle Database 19c Enterprise Edition, Release 19.19.0.0.0....
66 views0 comments
2 min
Can the Explain Plan of an SQL Query be accurate in Oracle Database
I have created a table "CUSTOMERS" with 1 million rows and an ID column as a primary key. SQL> SELECT COUNT(*) FROM CUSTOMERS; COUNT(*)...
27 views0 comments
1 min
Oracle Flashback Table Demo using SCN
Oracle Flashback query feature enables you to rewind the data of one or more tables prior to time with some limitations in length. This...
27 views0 comments
1 min
How to create a Global Temporary Table(GTT) in Oracle Database 19c
What is the Global Temporary table (GTT)? As the name suggests, GTTs are temporary tables that hold data only for the lifetime of your...
49 views0 comments
1 min
Trace down the IPs connected to the Oracle Database 19c on the Linux server
I am running an Oracle Database 19c on oracle linux 7.9. Now I need to check the IPs connected to my database on the listener port. We...
48 views0 comments
1 min
Is OMF enabled in your Oracle Database 12c and 19c
col name format a25 col value format a10 select a.ksppinm name, b.kspftctxvl value, b.kspftctxdf isdefault, decode(bitand(b.kspftctxvf,7)...
22 views0 comments
1 min
Add Temp files in Oracle Database 12c,19c
To add a temp file to the TEMP tablespace in Oracle Database, Query to find current tempfile details col file_name for a72 col...
87 views0 comments
1 min
Query to know the Primary keys of all tables in a Schema in Oracle Database
How query all primary keys of all tables owned by a schema_name - Just replace 'P' with 'F' to know foreign key select...
17 views0 comments
bottom of page