Home IT Linux Windows Database Network Programming Server Mobile  
           
  Home \ Database \ Oracle 11g maintenance partitions (eight) - Renaming Partitions     - Linux NFS service fixed ports and firewall configuration (Linux)

- 14 useful example Linux Sort command (Linux)

- How to set up HTTPS policies for older browsers (Server)

- Oracle RMAN-06023 and ORA-19693 errors (Database)

- To obtain installation package (RPM) under RHEL6 (Linux)

- Using LLVM Clang and Blocks under Linux (Programming)

- Make Linux more secure server tips (Linux)

- expdp reported ORA-39181 Export Processing Method (Database)

- How to install Docker and basic usage on Ubuntu 15.04 (Server)

- Oracle multi-table query optimization (Database)

- Report generation CPU, memory, and input and output ports with the sar command (Linux)

- Oracle GoldenGate Installation and Configuration Tutorial Introduction (Database)

- 25 Git Advanced Skills (Linux)

- Git uses a small mind (Linux)

- Linux dd command make U disk boot disk (Linux)

- CentOS 6.4 Python 2.6 upgrade to 2.7 (Linux)

- CentOS7 install NTFS-3G driver (Linux)

- UNIX and class UNIX system security check notes (Linux)

- Basic Operation Linux files and directories (Linux)

- Oracle database on the hit rate of query summary (Database)

 
         
  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:      
 
- To record command input under Linux (Linux)
- Linux Shell Scripting multithreading (Programming)
- CentOS 7.0 local address and configure yum source address priority (Linux)
- Linux filtration empty file command summary (Linux)
- Use Docker / LXC quickly launch a desktop system (Linux)
- Forgot Linux root password (Linux)
- How to release the cache memory on Linux (Linux)
- Installation under Linux Mint system guidelines for Gtk (Linux)
- Using shell users or virtual users to login to pureftpd (Linux)
- Fun music library in Linux using command line (Linux)
- Linear table with a Java implementation of the iterator (Programming)
- Install minimize RHEL / CentOS 7 things to do (Linux)
- Docker Basic Concepts (Linux)
- Java Concurrency: synchronized (Programming)
- Linux ls command (Linux)
- Taught you how to install Ubuntu Linux (Linux)
- Linux kernel likely and unlikely to resolve macro definitions (Linux)
- Log in CentOS 6.5 Multi-user setting VNC (Server)
- Linux installed and tested the deployment of Kafka distributed cluster (Server)
- To configure and use multiple Tomcat under Linux environment (Server)
     
           
     
  CopyRight 2002-2016 newfreesoft.com, All Rights Reserved.