Scripts Archives - Page 3 of 3 - ASRblogger

PARTITIONING

Adding partitions 11g/12c -- SYNTAX : ALTER TABLE <SCHEMA_NAME>.<TABLE_NAME> ADD PARTITION <PARTITION_NAME> VALUES LESS THAN < HIGH_VALUE> TABLESPACE <TABLESPACE_NAME > < UPDATE GLOBAL INDEXES(optional)>; -- NOTE: UPDATE GLOBAL INDEXES is…

asrblogger June 7, 2022No Comments

Determining the Size of Oracle database tables and indexes

Useful views to get index details: dba_indexes dba_segments dba_ind_columns dba_ind_partitions user_indexes user_segments user_ind_columns user_ind_partitions Query to check Index on a Table in Oracle. set lines 200 col index_name from a30…

asrblogger December 23, 2021No Comments

Recent Comments.

Anish Kumar on Installing PostgreSQL on Kubernetes Using CloudNativePG (CNPG)January 11, 2026
Thank you! I’m glad you found the articles and reviews informative, it motivates me to keep sharing quality content.
Anish Kumar on Installing PostgreSQL on Kubernetes Using CloudNativePG (CNPG)January 11, 2026
Really appreciate your feedback!
Anish Kumar on Installing PostgreSQL on Kubernetes Using CloudNativePG (CNPG)January 11, 2026
Thank you for taking the time to read it! I’m glad you found it helpful.
Anish Kumar on Installing PostgreSQL on Kubernetes Using CloudNativePG (CNPG)January 11, 2026
I really appreciate that! I believe detailed reviews help the community most, so happy it resonated.
Anish Kumar on Installing PostgreSQL on Kubernetes Using CloudNativePG (CNPG)January 11, 2026
Thank you! I always strive to make the details clear and valuable