Home IT Linux Windows Database Network Programming Server Mobile  
           
  Home \ Database \ Oracle 11g maintenance partitions (Seven) - Modifying Real Attributes of Partitions     - FFmpeg compiled with only H264 decoding library (Programming)

- Linux Shell Scripting Interview Question (Linux)

- Linux common network tools: hping Advanced Host Scan (Linux)

- Why do you need close contact Rust 1.0 (Programming)

- Configuring xdebug debugging environment in Ubuntu 14.04 under the PhpStorm (Linux)

- The method of CentOS-7.0. The installation and configuration of Tomcat-7 (Server)

- The ActiveMQ JMS installation and application examples for Linux (Linux)

- Linux system on a virtual machine to access the Internet (Linux)

- Graphical interface for the CentOS 6.4 installed and connected by remote VNC (Linux)

- Father of Python: Why Python zero-based index (Programming)

- Linux Getting Started tutorial: Experience QEMU virtual machine articles (Linux)

- Binary search -Java achieve (Programming)

- Atheros AR8161 / AR8162 network card driver problem solving in CentOS 6.4 (Linux)

- Service Discovery: Zookeeper vs etcd vs Consul (Server)

- SQL Server 2012 failover looksalive check and is alive check (Database)

- Use OpenWrt build WDS wireless network extension on V2 WHR-G300N (Linux)

- Linux Learning Notes: Users and Groups (Linux)

- Installation Flow N Play- interface stylized video player on Ubuntu (Linux)

- Oracle TDE transparent data encryption (Database)

- CentOS 6 adds disk quota limit (Linux)

 
         
  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:      
 
- Linux_Logo - output color ANSI Linux distributions logo command-line tool (Linux)
- Ubuntu install Eclipse for C / C ++ and related configuration (Linux)
- xCAT line installation on CentOS 6.X (Linux)
- Linux system security norms (Linux)
- Production environment Linux bonding method standby mode slave card switch (Server)
- To_teach you three strategies to prevent the LAN IP address theft (Linux)
- Java concurrent programming using the synchronized keyword ReentrantLock alternative primitive (Programming)
- VMware 8 installation configuration Win7, CentOS-7 Wizard (Linux)
- Docker + OpenvSwitch build experimental environment VxLAN (Server)
- Memory leak analysis using Android studio (Programming)
- Grep, Ack, Ag searches Efficiency Comparison (Linux)
- Hadoop virtualization performance comparison and tuning experience (Server)
- Ubuntu 14.04 Install WordPress on Nginx (Server)
- Use backup-manager system backup on Linux (Linux)
- Ubuntu 14.04 configure JDK1.8.0_25, switchable version (Linux)
- Shell generated using automated configuration script Orabbix (Database)
- Linux operating system security can not be ignored (Linux)
- There is sort of a directed acyclic graph topology (Programming)
- RedHat Linux 9.0 under P4VP-MX motherboard graphics resolution of problems (Linux)
- VMware6 achieve nat Internet (Linux)
     
           
     
  CopyRight 2002-2016 newfreesoft.com, All Rights Reserved.