Home PC Games Linux Windows Database Network Programming Server Mobile  
           
  Home \ Database \ Oracle 11g maintenance partitions (Seven) - Modifying Real Attributes of Partitions     - CentOS 6.x and CentOS7 installation RPMforge (Linux)

- On event processing browser compatibility notes (Programming)

- Android custom title bar (Programming)

- Preliminary understanding of SELinux security management (Linux)

- How to modify the Ubuntu terminal user name changed to red color (Linux)

- Java gets the current system time System.currentTimeMillis () (Programming)

- IP Security Policy is to learn how to prevent Ping and closed ports (Linux)

- Bootstrap 3.3.5 release download, Web front-end UI framework (Linux)

- PLSQL Developer synchronization table tools (Database)

- Use SVN to automatically deploy code under Apache (Server)

- JavaScript common functions summary (Programming)

- Kali Linux resolve GPG error KEYEXPIRED 1425567400 (Linux)

- apt-get and apt-cache show command examples (Linux)

- Use Ambari rapid deployment Hadoop big data environment (Server)

- RabbitMQ installation, configuration, monitoring (Linux)

- CentOS 7.0 Enable iptables firewall (Linux)

- Dockerfile use to build a mirror-based CentOS 7 (Linux)

- Summarize small problems encountered in the use Lua (Programming)

- GNU Linux system variables (sysctl configuration commands) integrated use (Linux)

- Nginx version of helloworld (Server)

 
         
  Oracle 11g maintenance partitions (Seven) - Modifying Real Attributes of Partitions
     
  Add Date : 2018-11-21      
         
         
         
  Modify existing partition a table or index properties is possible.

You can not change the TABLESPACE attribute. Use ALTER TABLE ... MOVE PARTITION / SUBPARTITION to a partition or sub-partition to the new table space.

Modify existing range or list partition properties

Use ALTER TABLE ... MODIFY PARTITION to modify the properties of an existing partition range or list partition. You can modify segment attributes (except TABLESPACE), or you can allocate and release area, identified as the local index partitions UNUSABLE, or rebuild local indexes identified as UNUSABLE.

If this is a composite hash-partitioned table range partitioning, please note the following:

If you assign or release a zone designated for each sub-partition partition will perform the operation;

Similarly, modify any other attribute causes the relevant properties of all sub-partition the partition is modified. Partition-level default attributes will be modified. In order to avoid modifying the properties of an existing sub-district, you can use the MODIFY DEFAULT ATTRIBUTES statement FOR PARTITION clause.

    The following is a partition to modify some examples of real property.

    This example modifies the sales range partitioned table sales_q1 MAXEXTENTS storage properties:

ALTER TABLE sales MODIFY PARTITION sales_q1

    STORAGE (MAXEXTENTS 10);

    In the following examples, in a range - hash partitioned table scubagear of partition ts1, all local index sub-partition is identified as UNUSABLE:

ALTER TABLE scubagear MODIFY PARTITION ts1 UNUSABLE LOCAL INDEXES;
    For the interval partitioned table, the partition, or you can modify the scope of the existing real property partition interval.
 

To modify an existing hash partition properties

    You can also use the ALTER TABLE ... MODIFY PARTITION statement to modify the properties of a hash partition. However, due to the physical properties of all of the individual hash partitions must be the same (except TABLESPACE), you are only limited to:

Assign a new area

The release of an unused area

Identifies a local index partition UNUSABLE

Reconstruction is identified as the local index partitions UNUSABLE

    The following example rebuild the dept table and hash-partitioned P1 all relevant local index partitions UNUSABLE:

ALTER TABLE dept MODIFY PARTITION p1

    REBUILD UNUSABLE LOCAL INDEXES;

To modify an existing sub-district property

    Use the ALTER TABLE MODIFY SUBPARTITION clause, you can perform the same operations previously listed only in the specified table sub-partition-level composite partition. E.g:

ALTER TABLE emp MODIFY SUBPARTITION p3_s1

    REBUILD UNUSABLE LOCAL INDEXES;

Modify existing index partition properties

    Use the ALTER INDEX MODIFY PARTITION clause, you can modify the actual property index partitions or sub-partitions. Rules and modify the table partition properties very similar, but for the ALTER INDEX statement MODIFY PARTITION clause is different, there is no rebuilding unusable index partition clause, but combined index partitions or sub-partitions clause. In this case, the merger means the combined index fast to release their re-use.

    You can also use the MODIFY PARTITION to allocate or free local index sub-partition, or identified as UNUSABLE.
     
         
         
         
  More:      
 
- Use in Linux ipmitool tool (Linux)
- Oracle Linux 5.5 (64bit) Install Oracle 11gR2 RAC detailed tutorial (Database)
- Open remote MySQL database connection managed under CentOS (Database)
- crontab cause CPU exception Analysis and Processing (Linux)
- Ubuntu simple method to track multiple time zones (Linux)
- How to install MySQL on Linux Dock (Database)
- MySQL5.6.12 Waiting for commit lock lead to hang from the library housing problem analysis (Database)
- Spacewalk Linux system configuration and installation (Linux)
- Unix / Linux commonly used to clean up disk space command (Linux)
- GitLab Installation Guide -Ubuntu 14.04 LTS (Server)
- Use Bosh deploy CloudFoundry problems encountered on OpenStack (Server)
- TOAD connect DB2 error SQL1460N solve (Database)
- Ubuntu 14.04 installed NVIDIA graphics driver (Linux)
- Python virtual environment: Virtualenv (Linux)
- Linux platform to prevent hackers to share practical skills (Linux)
- Oracle database, some basic grammatical structures (Database)
- Linux operation and maintenance of the actual file system, file links (Linux)
- Normal start Lazarus 1.0.8 under Ubuntu (Linux)
- Understanding the Linux load average on other UNIX-Like systems (Linux)
- C # get the current screenshot (Programming)
     
           
     
  CopyRight 2002-2022 newfreesoft.com, All Rights Reserved.