DBA Paradise

The place where DBAs grow

  • Home
  • Database
    • Oracle
    • SQL Server
    • Certification
  • My Courses
  • Personal Growth
  • About
  • Contact
READ vs SELECT Privilege

READ vs SELECT Privilege

Database Oracle Oracle
By dianarobete April 14, 2022 0

Are you aware of the READ object privilege in Oracle? If yes, what was your first thought of it when… Continue Reading

What Is Deferred Segment Creation?

What Is Deferred Segment Creation?

Database Oracle Oracle
By dianarobete April 11, 2022 0

Did you know that deferred segment creation was introduced in 11.2? Some DBAs might not be familiar with this concept… Continue Reading

What Is The Difference Between Oracle Table And Oracle Segment?

What Is The Difference Between Oracle Table And Oracle Segment?

Database Oracle Oracle
By dianarobete March 17, 2022 0

DBAs use these two concepts interchangeably: table and segment, more precisely table segment. Why is that? When we think of… Continue Reading

How To Get Historical Row Count In a Table?

How To Get Historical Row Count In a Table?

Database Oracle Oracle
By dianarobete March 12, 2022 0

Have you been in a situation where you had to prove the row count in a table has changed or… Continue Reading

What Is Oracle’s Identity Column?

What Is Oracle’s Identity Column?

Database Oracle Oracle
By dianarobete March 1, 2022 0

Did you know about a database feature that was introduced with 12c, but is not widely used?This feature would make… Continue Reading

How Can NLS_DATE_FORMAT Help You?

How Can NLS_DATE_FORMAT Help You?

Database Oracle Oracle
By dianarobete January 12, 2022 0

When you connect to the Oracle database, anything that has the DATE datatype, is displayed in the default format of… Continue Reading

What Is Oracle Instance Recovery?

What Is Oracle Instance Recovery?

Database Oracle Oracle
By dianarobete January 6, 2022 0

Oracle instance recovery occurs automatically when you try to startup and open a database that crashed or was shutdown abort.… Continue Reading

3 Datapump Parameters That Will Change Your Life

3 Datapump Parameters That Will Change Your Life

Database Oracle Oracle
By dianarobete December 14, 2021 2

Did I get your attention with the title? Well maybe these parameters are not really life changing, but at least… Continue Reading

How To Allow Blank Lines In Your SQL Statements: SQLBLANKLINES

How To Allow Blank Lines In Your SQL Statements: SQLBLANKLINES

Database Oracle Oracle
By dianarobete November 2, 2021 1

Today’s post will give you a quick and easy tip. Did it ever happen to you to receive a script… Continue Reading

How To Synchronize Applications

How To Synchronize Applications

Database Oracle Oracle
By dianarobete September 27, 2021 0

In previous blog post we talked about maintenance in the application root container. If you remember, I mentioned that the… Continue Reading

Posts navigation

1 2 … 21 Next

Recent Posts

  • READ vs SELECT Privilege
  • What Is Deferred Segment Creation?
  • What Is The Difference Between Oracle Table And Oracle Segment?

Recent posts

READ vs SELECT Privilege

READ vs SELECT Privilege

April 14, 2022 0
What Is Deferred Segment Creation?

What Is Deferred Segment Creation?

April 11, 2022 0
What Is The Difference Between Oracle Table And Oracle Segment?

What Is The Difference Between Oracle Table And Oracle Segment?

March 17, 2022 0
How To Get Historical Row Count In a Table?

How To Get Historical Row Count In a Table?

March 12, 2022 0
What Is Oracle’s Identity Column?

What Is Oracle’s Identity Column?

March 1, 2022 0
How Can NLS_DATE_FORMAT Help You?

How Can NLS_DATE_FORMAT Help You?

January 12, 2022 0
What Is Oracle Instance Recovery?

What Is Oracle Instance Recovery?

January 6, 2022 0
3 Datapump Parameters That Will Change Your Life

3 Datapump Parameters That Will Change Your Life

December 14, 2021 2

Recent Posts

  • READ vs SELECT Privilege
  • What Is Deferred Segment Creation?
  • What Is The Difference Between Oracle Table And Oracle Segment?

Lets Get Technical

Terms Of Service
Privacy Policy
Contact Us

Credits

Website Logo: Travel And Tourism graphic by Freepik from Flaticon is licensed under CC BY 3.0. Made with Logo Maker

Proudly powered by WordPress | Theme: Balanced Blog