Hello Oracle Community,
I need to understand how partitioning can be applied to tables for an oracle 11.2.0.4.0 database.
Please start a discussion with me. After the go live , the production database will grow very quickly. Currently a DBA on client side is partitioning the tables on the fly when it is needed and I am not sure what scripts or logic he is using. I will have to take over this responsibility soon.
My Job/Task/Goal:
Each important table has specifications for the type of partitioning that will need to be implemented to handle the data. Which I will be applying.
For example using the following parameters to partition a table.:
1. Table: Clogs
2. Schema: Schema name
3. Range Partition on ISSUEDATE
4. Group partition by daily.
5. Partition Naming Convention : clogmd_YYYYMMDD
Note: I have no idea where to start. I have a 5 years of IT and Systems Admin experience but I am not an expert but I am not a complete newbie either.
Some of the code I am working with is.
1. ALTER TABLE tableowner.tablename drop partition partitionname_YYYYMMDD (respective partitionname)
2. ALTER TABLE tableowner.tablename split partition maxpartitionname_YYYYMMmax at (to_date('YYYY-MM-DD 00:00:00','SYYYY-MM-DDHH24:MI:SS')) into (partition NAME_YYYYMMDD tablespace name_WXY1, partition NAME_201602MAX tablespace NAME_WXY2;
3. ALTER TABLE tableowner.tablename add partition NAME_YYYYMMDD (respective PARTITIONNAME);
Please guide me and let me know of any considerations I should be taking. I greatly appreciate any help.
Thank you!