Home IT Linux Windows Database Network Programming Server Mobile  
           
  Home \ Database \ Oracle 11g maintenance partitions (Seven) - Modifying Real Attributes of Partitions     - Android main thread message system (Handler Looper) (Linux)

- OpenGL Superb Learning Notes - New Patterns (Programming)

- Ubuntu 12.04 commonly use shortcuts finishing Share (Linux)

- RHEL7 unattended automatic installation DHCP + TFTP + SYSLINUX + TFTP + Kickstart (Linux)

- Linux Regular expressions grep and egrep (Linux)

- GitLab remote backup of Linux Shell Scripting (Linux)

- Access clipboard content across multiple vim instances in a terminal (Linux)

- Some of the bibliographic management tools to good use on linux (Linux)

- Java regular expression syntax (Programming)

- Linux System Getting Started Tutorial: How to Force Change your password at next logon Linux (Linux)

- CentOS static IP network configuration (Linux)

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

- SUSE Linux install Oracle 10g and problem solving (Linux)

- Android Studio commonly used shortcuts and how to follow the Eclipse Shortcuts (Linux)

- GAMIT10.5 under CentOS installation (Linux)

- Docker: Mirroring and container operations (Server)

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

- Linux can modify the maximum number of open files (Linux)

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

- Tsunami-udp accelerated network transmission (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:      
 
- The wrong in Linux: too many open files (Linux)
- NIC configuration parameters under Linux (Linux)
- Analysis of Java reflection mechanism (Programming)
- MySQL remote connection settings (Database)
- Linux file permissions bit forced bits and adventure Comments (Linux)
- fcntl file locking function add (Programming)
- Basic Tutorial: Linux novice should know 26 commands (Linux)
- Linux iptables port mapping settings (Server)
- RabbitMQ user roles and access control (Linux)
- Installation of Python2.7.10 under CentOS 6.4 (Linux)
- iOS used in the development --UITabBarController tag controller (Programming)
- CentOS cross compiler core Raspberry Pi 2 (Linux)
- To install PXE + Kickstart under CentOS 6.x operating system (Linux)
- MySQL Statistics (Database)
- Puppet subcommands Introduction (Server)
- Four IDS intrusion detection tool under Linux environment (Linux)
- The basic principle of pointers in C ++ (Programming)
- Beautiful start Ubuntu installation tool Duck Launcher 0.64.5 (Linux)
- Recycle Bin function realization in Linux (Linux)
- How to make GRub instead of the default Ubuntu software center (Linux)
     
           
     
  CopyRight 2002-2016 newfreesoft.com, All Rights Reserved.