In previous article we saw the benefits of partition pruning. Partition Pruning in Oracle Here we will see how partition pruning takes place when you run the query accessing your partitioned table. For instance , you have transaction table from year 2011 to 2019 with different partition for each year. And you want statement of […]
Monthly Archives: June 2019
Partition Pruning in Oracle
Pruning itself means to cut the dead parts and work on the pieces which are indeed important one. In Oracle partition pruning works in the same manner. Oracle can recognize which partitions and sub-partitions need to be eliminated and which partitions should be accessed for the query to be processed. When you have created some […]
Types of Index Partitions
In previous article we have seen overview of index partitioning and advantages of it. In this article we will see example of different types of indexes on partitioned tables. 1.Non-partitioned Index: We can create normal non-partitioned index on partitioned table. Example : TRANSACTIONS table is partitioned table in my database. 2.Global Range Partitioned Indexes : […]
Composite Partitioning in Oracle
In this article we will see examples of various types of composite partitions 1.RANGE-HASH composite partitioning : 2.LIST-HASH composite partitioned table 3.LIST-RANGE Partitioned table : 4.LIST-LIST partitioned table 5.RANGE-LIST Partitioned table : 6.RANGE-RANGE Partitioned table : Thank you for giving your valuable time to read the above information. If you want to be updated with […]
Types of Table Partitions in Oracle
In this article we will see types of partitions available in Oracle. Range Partitioning : Range Partitioning works with range of column values. It sets lower boundaries and upper boundaries to the partition. It is widely used with DATE data types. Lets create one range partition to understand it better.It is generally used with DATE […]
Index Partitioning
In previous article we saw what is partitioning in oracle and the benefits it brings . http://oracle-help.com/oracle-database/oracle-partitioning/ In this article we will see Index partitioning. Indexes are the essential part of any SELECT and DML operations which we run on the database. So , when we tune the table we must consider […]
ORA-14652: reference partitioning foreign key is not supported
Note : while creating reference partitioning table , foreign key must be not null
How Insert Statement Works
When Oracle receives sql/insert query, it requires to run some pre-tasks before actually being able to really run the query. During parsing, Database validate the syntax of the statement whether the query is valid or not. Database validate the semantic of the statement. It checks whether a statement is meaningful or not. […]
Oracle Cloud Platform Systems Management 2018 Associate (1Z0-930)
Hi Readers Finally, I’ve successfully passed 1Z0-930, Oracle Cloud Platform Systems Management 2018 Associate. It was almost more than 3 months that I’ve been preparing for this. The Exam contains 70 questions related to Oracle Management Cloud. To earn this certification you need to get 70% marks. This was the result of the journey: Oracle Cloud […]
Oracle Partitioning
As a DBA we must have heard about Partitioned tables or Partitioned index in our tenure or may be we have used it at some extent.Here in this post we will see what is Partitioning and what benefits it brings. The first question that arises is What is Partitioning ? Partitioning means dividing your large […]