Adding Partition To Existing Table In Oracle

How do I alter my existing table to create a range partition in Oracle

Creating partition is on a table is very important when you want to see performance improvement especially on DATE columns.

In this post, We will learn how to alter existing table with partition.

How to Create User and Grants in Oracle

What is Partition in Oracle:

Oracle Partitioning allows tables and indexes to be partitioned into smaller, more manageable units, providing database administrators with the ability to pursue a "divide and conquer" approach to data management. ... That table could be range- partitioned so that each partition contains one day of data.

How to Create a User and Grant Permissions in Oracle

In this post, Learn how to create a user in oracle and How to provide grant permissions to the user in oracle.

How to Create a User in Oracle

Before creating a user in oracle, you must have admin access or system privilege to create new user and to create session.

Connect to Oracle as sysdba using following command. We are running this tutorial in Oracle 18C version.

H:\>sqlplus / as sysdba

Output:

H:\>sqlplus / as sysdba

SQL*Plus: Release 18.0.0.0.0 - Production on Tue Apr 16 12:47:26 2019
Version 18.3.0.0.0

Copyright (c) 1982, 2018, Oracle.  All rights reserved.


Connected to:
Oracle Database 18c Enterprise Edition Release 18.0.0.0.0 - Production
Version 18.3.0.0.0

SQL>

Only a user authenticated AS SYSASM/SYSDBA to create the user.