At times one would want to change properties/attributes of a table so new partitions are affected by change not the partitions already created, like example compression, change PCTFREE, default tablespace. -- enable compression for all operations and change PCTFREE SQL> ALTER TABLE scott.part_table MODIFY DEFAULT ATTRIBUTES COMPRESS FOR ALL OPERATIONS PCTFREE 5; -- Change default tablespace for new partitions SQL> ALTER TABLE scott.part_table MODIFY DEFAULT … Continue reading How to change properties/attributes of partition table?
When clicking on Properties, SQLServer could display the following error message “Property Owner is not available for Database ‘[DatabaseName]’. This property may not exist for this object, or may not be retrievable due to insufficient access rights. (Microsoft.SqlServer.Smo)” One of the reason why this may occur if the login in the database was deleted and the login was the owner of the database. The following … Continue reading Property Owner is not available for Database error message