Oracle Blog

Oracle Blog

Oracle SQL, PL/SQL and APEX

  • About Me

Category: DBA

How to create a temporary job

Posted on 26/12/202026/12/2020 by admin

Basically, you can create a single scheduler job by the following syntax. This job executes and drops itself automatically. If your procedure that used in the scheduler job […]

More Details
Posted in DBA, PL/SQLLeave a Comment on How to create a temporary job

How to use Data Pump between different Oracle versions

Posted on 04/12/202004/12/2020 by admin

According to the documentations, if the target database is higher than the source database, the VERSION parameter does not have to be specified. There is an exception, if […]

More Details
Posted in DBALeave a Comment on How to use Data Pump between different Oracle versions

How to export / import schema with Data Pump

Posted on 23/11/202004/12/2020 by admin

There are several export/import modes. These are listed in the following section. Full Mode Schema Mode Table Mode Tablespace Mode Transportable Tablespace Mode In this article I will discuss about schema mode export […]

More Details
Posted in DBALeave a Comment on How to export / import schema with Data Pump

Adaptive Cursor Sharing & Histograms

Posted on 24/05/202025/05/2020 by admin

Adaptive cursor sharing has been used in Oracle 11g first. This feature enables a single statement that contains bind variables to use multiple execution plans. According to the […]

More Details
Posted in DBA, SQL1 Comment on Adaptive Cursor Sharing & Histograms

In-Doubt Transactions and ORA-02049 timeout distributed transaction waiting for lock

Posted on 29/01/202003/04/2021 by admin

Distributed transactions perform DML on multiple databases. If any issue occurs during this transaction such as network or system problems etc. The transaction becomes in-doubt. Normally, Oracle’s RECO […]

More Details
Posted in DBALeave a Comment on In-Doubt Transactions and ORA-02049 timeout distributed transaction waiting for lock

Proxy user authentication

Posted on 18/12/201913/07/2022 by admin

Proxy user authentication allows you to access another schema via a different user. In other words, dba can connect on behalf of a specific user without knowing the […]

More Details
Posted in DBALeave a Comment on Proxy user authentication

How to change database log mode to archiving mode

Posted on 05/12/201915/12/2019 by admin

After connect to the database via SQLPLUS. Shutdown the database using the NORMAL, IMMEDIATE, or TRANSACTIONAL option. We can start the database with mount mode. Now, we can alter the […]

More Details
Posted in DBA1 Comment on How to change database log mode to archiving mode

Create an Access Control List (ACL)

Posted on 18/03/201915/12/2019 by admin

Access control list can be created, amended and deleted by DBMS_NETWORK_ACL_ADMIN package. It is used for network access. For instance, XML transfer etc. The following code can create […]

More Details
Posted in DBALeave a Comment on Create an Access Control List (ACL)

Data encryption and decryption using PL/SQL

Posted on 24/01/201924/01/2019 by admin

Data encryption is the one of the key feature for security. It can be used for several purposes. I used DBMS_CRYPTO package for this. DBMS_CRYPTO.ENCRYPT function requires the […]

More Details
Posted in DBA, PL/SQL1 Comment on Data encryption and decryption using PL/SQL

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

Posts navigation

Older posts
Newer posts

Recent Posts

  • How to fix cardinality misestimate?
  • CUME_DIST function
  • FOR UPDATE vs FOR UPDATE SKIP LOCKED
  • NVL vs COALESCE
  • How to use MULTISET UNION DISTINCT on collections

Recent Comments

  • admin on How to reorder columns of table
  • Yogendra on How to reorder columns of table
  • ENOCK OLOO on Data encryption and decryption using PL/SQL
  • Soeren Dalby on How to generate, parse and use JSON data
  • Nicolas on Print clob data with htp.prn

Archives

  • May 2023
  • January 2023
  • October 2022
  • April 2022
  • March 2022
  • February 2022
  • January 2022
  • December 2021
  • November 2021
  • June 2021
  • May 2021
  • April 2021
  • March 2021
  • February 2021
  • 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
  • Uncategorized
  • XQuery

Flag Counter

© Copyright 2023, Çağlar Polat