Oracle Blog

Oracle Blog

Oracle SQL, PL/SQL and APEX

  • About Me

Category: DBA

ORA-12034 materialized view log on younger than last refresh

Posted on 21/12/201807/01/2019 by admin

Hi all, if you encounter ORA-12034 error. It means, a complete refresh is required before the next fast refresh. So, I run the code below in order to […]

More Details
Posted in DBALeave a Comment on ORA-12034 materialized view log on younger than last refresh

Regular Expression

Posted on 20/12/201824/01/2019 by admin

You can use the following character classes for your regex pattern. Character Class Description [:alnum:] Alphanumeric characters [:alpha:] Alphabetic characters [:blank:] Blank Space Characters [:cntrl:] Control characters (nonprinting) […]

More Details
Posted in DBA, SQLLeave a Comment on Regular Expression

How to update user’s password with the same password

Posted on 19/12/201805/02/2020 by admin

If you don’t know the user’s password that had been saved in TOAD or SQL DEVELOPER and will expire soon. You can update as it is. In Oracle […]

More Details
Posted in DBALeave a Comment on How to update user’s password with the same password

JOB_QUEUE_PROCESSES parameter

Posted on 13/12/201805/02/2020 by admin

In our company we came across duplicative jobs that have been executed by the system. After an investigation, we find out that, these jobs were run from our […]

More Details
Posted in DBALeave a Comment on JOB_QUEUE_PROCESSES parameter

Posts navigation

Newer posts

Recent Posts

  • How to use Flashback
  • How to open pluggable database automatically
  • How to create a temporary job
  • How to use Data Pump between different Oracle versions
  • How to export / import schema with Data Pump

Recent Comments

  • ismail kılıç on How to change database log mode to archiving mode
  • Mark on Trigger dialog close event in Apex

Archives

  • January 2021
  • December 2020
  • November 2020
  • May 2020
  • February 2020
  • January 2020
  • December 2019
  • May 2019
  • March 2019
  • January 2019
  • December 2018
  • November 2018

Categories

  • APEX
  • DBA
  • PL/SQL
  • SQL
  • XQuery
© Copyright 2021, Çağlar Polat