Loading...

Follow ORACLE-HELP - Oracle DBA and Cloud Articles on Feedspot

Continue with Google
Continue with Facebook
or

Valid

In this post, we can use GitHub reposirotry to fetch the repos and then be installing the Oracle Database 18c.  GitHub must be ..read more
  • Show original
  • .
  • Share
  • .
  • Favorite
  • .
  • Email
  • .
  • Add Tags 
Sometimes we face issues like OEM agent 12c crashed and found the below error messages on gcagent.log[/agent_inst/sysman/log/gcagent.log ..read more
  • Show original
  • .
  • Share
  • .
  • Favorite
  • .
  • Email
  • .
  • Add Tags 
We can exchange subpartition in oracle the same way we exchange partition.Let’s see few examples. 1.Exchange subpartition of *-Hash ..read more
  • Show original
  • .
  • Share
  • .
  • Favorite
  • .
  • Email
  • .
  • Add Tags 
1.Exchange Partition of *-List Partition Here I took example of Range-List partitioning method. SQL> CREATE TABLE LIST_COMP_PART ..read more
  • Show original
  • .
  • Share
  • .
  • Favorite
  • .
  • Email
  • .
  • Add Tags 
Let’s create Interval-Partitioned table and exchange partitions. Step 1 : Create Interval Partitioned Table SQL> CREATE TABLE ..read more
  • Show original
  • .
  • Share
  • .
  • Favorite
  • .
  • Email
  • .
  • Add Tags 
Oracle 11g came up with concept of Virtual Column which is created with expression. Which does not stores data physically rather it ..read more
  • Show original
  • .
  • Share
  • .
  • Favorite
  • .
  • Email
  • .
  • Add Tags 
Read-Only partitions are of benefits 1.When you are working in Data-Warehouse environment there must be many partitions which are not ..read more
  • Show original
  • .
  • Share
  • .
  • Favorite
  • .
  • Email
  • .
  • Add Tags 
In my previous composite partitioning in oracle article I saw example of various types of composite partitioning methods. In addition to ..read more
  • Show original
  • .
  • Share
  • .
  • Favorite
  • .
  • Email
  • .
  • Add Tags 
In previous post we saw modifying non-partitioned table into partitioned one.Today we will see how we can convert partitioned table into ..read more
  • Show original
  • .
  • Share
  • .
  • Favorite
  • .
  • Email
  • .
  • Add Tags 
Here we will see examples to add partition in all different types of partitioning methods. 1.Add Partition in Range-Partitioned table ..read more

Read for later

Articles marked as Favorite are saved for later viewing.
close
  • Show original
  • .
  • Share
  • .
  • Favorite
  • .
  • Email
  • .
  • Add Tags 

Separate tags by commas
To access this feature, please upgrade your account.
Start your free month
Free Preview