The parameter that needs to be passed and their description are as follows: Creating monthly partition procedure accepts the following input parameters:

a)Name of the table.

b)Table Alias.

c)Date from which the partition needs to be created.

d)Date upto which the partition needs to be created.

e)Tablespace for the specified table.

Creating daily partition procedure accepts the following input parameters:

 a)Name of the table.

b)Table Alias.

c)Date from which the partition needs to be created.

d)Date upto which the partition needs to be created.

e)Tablespace for the specified table.

Removing date partition from a table.

a)Name of the table.

b)Table Alias.

c)Date upto which the partition needs to be created.

Converting a non-partitioned table to a partitioned table.

 a)Name of the table.

b)Schema in which the table resides.

c)Column on which the partition needs to be created.

d)Partition alias.

e)Date from which the partition needs to be created.

f)Date upto which the partition needs to be created.

g)Temporary table drop option.