Home IT Linux Windows Database Network Programming Server Mobile  
           
  Home \ Database \ Oracle 11g maintenance partitions (Seven) - Modifying Real Attributes of Partitions     - Bash variable expansion modifier (Programming)

- Use netcat [nc] command on Linux and Unix port scan (Server)

- CentOS install expect (Linux)

- AWK principles and commands and file input (Linux)

- To achieve a two-way static NAT stateless available modules on Linux (Linux)

- MySQL DATE_FORMAT () function (Database)

- Oracle 10g in the unique and index problems (Database)

- Ubuntu iptables prevent IP attacks (Linux)

- Guide: Trickle restrict application bandwidth usage (Linux)

- Linux command binlog by filtering out the complete SQL statement (Database)

- Java Generics (Programming)

- Mutt - an email client that sends messages through the terminal (Linux)

- To learn linux security (Linux)

- Command-line based tools for better alternatives (Linux)

- Docker build private warehouse (Server)

- JavaScript basic tools list (Programming)

- Three methods easy data encryption on Linux (Linux)

- 10 Codes of good practice PHP (Programming)

- Schema snapshot rollback (Database)

- Based on a complete solution RMI service to transfer large files (Programming)

 
         
  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:      
 
- how to quickly find a file on Linux system (Linux)
- Git delete files (Linux)
- Linux FAQ - How to fix tar:Exitingwith failure status due to previous errors (Linux)
- Hibernate4 The Hello World (basic environmental structures) (Programming)
- Apache Tomcat integration and resin (Server)
- Ubuntu install Scala 2.10.x version (Linux)
- apt-get install openstack pkg Troubleshooting (Linux)
- The file name is garbled or deleted files with special characters under Linux (Linux)
- Learning UNIX good habits (Linux)
- Depth Java Singleton (Programming)
- Install mono offline on CentOS (Server)
- On FreeBSD 10.2 Bugzilla how to install and configure Apache SSL (Server)
- CentOS7 yum install third-party source EPEL (Linux)
- Linux server network penetration testing (Linux)
- Oracle multi-table query optimization (Database)
- Will Laravel become the most successful PHP framework? (Programming)
- Linux - Common process the command (Linux)
- Three kinds of implementation model of the Linux thread history (Programming)
- CentOS 7.0 running Docker kernel error solution (Server)
- Transfer files to Windows and Linux (Linux)
     
           
     
  CopyRight 2002-2016 newfreesoft.com, All Rights Reserved.