Home IT Linux Windows Database Network Programming Server Mobile  
           
  Home \ Database \ Oracle 11g maintenance partitions (eight) - Renaming Partitions     - An example of troubleshooting of embedded Linux OpenWRT (Linux)

- Debian Stable (Jessie 8.1) of normal.mod not found (Linux)

- Linux text processing tool of awk (Linux)

- Online booking shocking information leakage risk, you dare book the tickets online? (Linux)

- C language to view various types of data size (Programming)

- Java Network Programming Internet address lookup (Programming)

- About Java 7 module system (Programming)

- Linux memory management -free learning experience (Linux)

- pureftpd basis: Install, configure, implement, anonymous logon (Linux)

- How to clean up your Ubuntu 14.10 / 14.04 / 13.10 system (Linux)

- Linux performance monitoring - CPU, Memory, IO, Network (Linux)

- The file name is garbled or deleted files with special characters under Linux (Linux)

- Text analysis tools - awk (Linux)

- Introduces Linux kernel compilation system and compiler installation (Linux)

- Shell array: Define Shell array, the array length (Programming)

- Ubuntu font settings: Using Windows Font (Linux)

- Eclipse-4.4 crash problem solving under Debian-7.6 (Linux)

- Talking about the shortcomings and deficiencies of the firewall (Linux)

- Linux, Chrome browser font settings beautification (Linux)

- Doubly linked list basic operations (Linux)

 
         
  Oracle 11g maintenance partitions (eight) - Renaming Partitions
     
  Add Date : 2018-11-21      
         
       
         
  We can rename tables and indexes and child partitions. Renaming a partition One reason may be assigned a meaningful name, not the other system maintenance operations default name assigned to the partition.

All partitioning methods are supported using the FOR (value) to identify a partition. You can use this method to rename a partition name automatically generated, replacing it with a more meaningful name. This is particularly useful for re-zoning or a composite partition table.

You can individually rename the partition table referenced in the main table and the child table and child partitions. Re-naming operations master table is not cascaded to the relevant sub-tables.

Rename table partitions

Rename a range, hash, or list partition, use the ALTER TABLE ... RENAME PARTITION statement. E.g:

ALTER TABLE scubagear RENAME PARTITION sys_p636 TO tanks;

Rename the table sub-partition

Similarly, you can develop a new name to the sub-partition table. In this case you want to use ALTER TABLE ... RENAME SUBPARTITION syntax.

Rename index partition

Index and child partitions can also be carried out in a similar manner to rename, use the ALTER INDEX syntax.

Rename an index partition

Use ALTER INDEX ... RENAME PARTITION statement to rename an index partition.

ALTER INDEX statement does not support the use of FOR (value) to identify a partition. In the rename operation you have to use the original name of the partition.

Renaming an index sub-partitions

The following statement simply describes how to rename an increase to the base table partition partition name generated by default:

ALTER INDEX scuba RENAME SUBPARTITION sys_subp3254 TO bcd_types;
     
         
       
         
  More:      
 
- Linux can modify the maximum number of open files (Linux)
- Java Foundation - implicit conversion vs cast (Programming)
- Hadoop namenode do NFS disaster recovery (Server)
- MongoDB Learning the notes (Database)
- Keepalived + HAProxy high availability load balancing (Server)
- How Vim playing a mature IDE (Linux)
- Nginx + ownCloud + PHP + MySQL to build personal private cloud under CentOS7 (Server)
- MBR partitions under Linux (Linux)
- Precautions against hackers Linux environment (Linux)
- When Vim create Python scripts, vim autocomplete interpreter and encoding method (Programming)
- Linux installation is larger than 2TB (UEFI interface) hard disk solution (Linux)
- For the FreeBSD install Adobe Flash plug-in (Linux)
- Ubuntu Linux use MAC binding against ARP attacks (Linux)
- Changes in C # asynchronous programming model (Programming)
- Close common port to protect server security (Linux)
- Using Python multithreaded mistakes summary (Programming)
- Use top to monitor the remote server (Server)
- Use netcat [nc] command on Linux and Unix port scan (Server)
- Let 32 Linux / CentOS system to support more than 4G memory (Linux)
- Protect against network attacks using Linux system firewall (Linux)
     
           
     
  CopyRight 2002-2016 newfreesoft.com, All Rights Reserved.