DBA Paradise

The place where DBAs grow

  • Home
  • Database
    • Oracle
    • SQL Server
    • Certification
  • My Courses
  • Personal Growth
  • About
  • Contact
Troubleshooting ORA-39034: Table TABLE_DATA: X does not exist.

Troubleshooting ORA-39034: Table TABLE_DATA: X does not exist.

Database Oracle Oracle
By dianarobete May 27, 2020 1

Have you received “ORA-39034: Table TABLE_DATA: X does not exist“, while executing an import operation? Were you scratching your head,… Continue Reading

How To Move Datafiles Online Quickly?

How To Move Datafiles Online Quickly?

Database Oracle Oracle
By dianarobete May 21, 2020 1

Last week was the launch of my new course on Udemy! I would like to thank you all for your… Continue Reading

What Is Shadow Lost Write Protection And How To Enable It

What Is Shadow Lost Write Protection And How To Enable It

Database Oracle Oracle
By dianarobete May 4, 2020 0

Shadow Lost Write Protection was introduced in 18c, and of course is available with 19c as well. Data block lost… Continue Reading

Quick and Easy Steps To Change Database Name

Quick and Easy Steps To Change Database Name

Database Oracle Oracle
By dianarobete April 24, 2020 1

When was the last time you had to change the name of a database? Long time ago, changing the database… Continue Reading

4 Things About Schema Only Accounts You Should Know

4 Things About Schema Only Accounts You Should Know

Database Oracle Oracle
By dianarobete March 28, 2020 0

Let’s continue learning about 19c. Some of the things I’ll talk about are not new to 19c, however they are… Continue Reading

Stay Safe, Stay Healthy, Stay Positive, Stay Inside

Stay Safe, Stay Healthy, Stay Positive, Stay Inside

Database Oracle Oracle
By dianarobete March 20, 2020 0

These are unprecedented times that we live in! I just wanted to send word out to my readers to stay… Continue Reading

How To Quickly Terminate A Session Or Cancel A SQL Statement

How To Quickly Terminate A Session Or Cancel A SQL Statement

Database Oracle Oracle
By dianarobete March 5, 2020 0

Terminating sessions is something that DBAs are asked to do pretty often.Usually the request comes in the form of an… Continue Reading

Four Ways to Startup or Shutdown Your 19c Database

Four Ways to Startup or Shutdown Your 19c Database

Database Oracle Oracle
By dianarobete February 20, 2020 2

Can you use Oracle Enterprise Manager Database Express, or Oracle Cloud Database Express to startup or shutdown your database? Think… Continue Reading

SQL Quarantine In Action On Your Laptop

SQL Quarantine In Action On Your Laptop

Database Oracle Oracle
By dianarobete February 14, 2020 0

Last week I gave you a taste for SQL Quarantine. Some of you asked me if I know when this… Continue Reading

Intro To SQL Quarantine

Intro To SQL Quarantine

Database Oracle
By dianarobete February 6, 2020 1

In the last blog post we talked about Quarantined Objects, which have no relationship whatsoever with today’s topic. I just… Continue Reading

Posts navigation

Previous 1 2 3 4 … 18 Next

Recent posts

How To Create A PDB From Scratch

How To Create A PDB From Scratch

January 12, 2021 0
Intro To Multitenant Architecture

Intro To Multitenant Architecture

January 2, 2021 1
Real-time Stats in Action

Real-time Stats in Action

December 18, 2020 0
Online Stats in Action

Online Stats in Action

November 26, 2020 0
Online Stats vs Real-time Stats

Online Stats vs Real-time Stats

November 12, 2020 0
Can an inactive session block other sessions?

Can an inactive session block other sessions?

November 3, 2020 0
Learn Something New About Alter Table Move

Learn Something New About Alter Table Move

October 21, 2020 0
19c LISTAGG Can Do Distinct

19c LISTAGG Can Do Distinct

October 15, 2020 0

Proudly powered by WordPress | Theme: Balanced Blog