Home PC Games Linux Windows Database Network Programming Server Mobile  
           
  Home \ Database \ Oracle table space rename and delete table space     - Bug tracking library after FastJson omitted the decimal point 0 (Programming)

- Linux tar compressed exclude a folder (Linux)

- Installation in lxml Python module (Linux)

- Git build a team development environment operating drills (Linux)

- HDFS Distributed File System Resource Manager Developer summary (Server)

- Source MongoDB 3.2.1 installed on CentOS6.5 (Database)

- Ubuntu 14.04 install the NVIDIA driver + CUDA + MATLAB (Linux)

- Linux system package manager (rpm, yum, source packages installation) (Linux)

- Oracle how to assess the true concurrent session (Database)

- CentOS 6.5 set under Oracle 12c at startup (Database)

- Common Linux System Troubleshooting (Linux)

- Import and export myloader accelerate mydumper (Database)

- Python common data type summary (Programming)

- Hunk / Hadoop: Performance Best Practices (Server)

- MySQL my.cnf sql_mode schema modifications (Database)

- Linux system performance and usage activity monitoring tools -Sysstat (Linux)

- Linux Oracle environment variable is invalid Problem Solving (Database)

- Repair Chrome for Linux is (Linux)

- About enhanced Linux / Unix server system security program (Linux)

- Git Tutorial Comments (Linux)

 
         
  Oracle table space rename and delete table space
     
  Add Date : 2018-11-21      
         
         
         
  In case of need, you can modify the name of the table space. Modify the name of the table space will not affect the data table space. But can not modify the system table space system and sysaux name.
Rename table space syntax is as follows:
alter tablespace tablespace_name rename to new_tablespace_name;
note:
If the table space state is offline, you can not rename the table space.
Delete table space
Delete table space need to use drop tablespace statement, its syntax is as follows:
drop tablespace tablespace_name [including contents [and datafiles]]
The syntax follows:
including contents
It means to delete the table space at the same time, delete all database objects in the table space. If you have a database table space objects, you must use this option.
and datafiles
Means to delete the table space at the same time, remove the table space corresponding to the data file. If this option is not applicable, then delete the table space is merely removed from the data dictionary and the control file information about the table space, but does not delete the operating system with the corresponding table space data file.

SQL> select tablespace_name, status from dba_tablespaces;

TABLESPACE_NAME STATUS
------------------------------ ---------
SYSTEM ONLINE
SYSAUX ONLINE
UNDOTBS1 ONLINE
TEMP ONLINE
USERS ONLINE
MYTEMP ONLINE
TEMPGROUP ONLINE
TEMPGROUP02 ONLINE
MYBIGSPACE ONLINE
BLOCKSPACE ONLINE
INSPUR ONLINE
TESTSPACE ONLINE
TEST ONLINE
Line 13 has been selected.

SQL> alter tablespace mytemp rename to userspace;

Table space has changed.

SQL> select tablespace_name, status from dba_tablespaces;

TABLESPACE_NAME STATUS
------------------------------ ---------
SYSTEM ONLINE
SYSAUX ONLINE
UNDOTBS1 ONLINE
TEMP ONLINE
USERS ONLINE
USERSPACE ONLINE
TEMPGROUP ONLINE
TEMPGROUP02 ONLINE
MYBIGSPACE ONLINE
BLOCKSPACE ONLINE
INSPUR ONLINE
TESTSPACE ONLINE
TEST ONLINE

Line 13 has been selected.

SQL> drop tablespace userspace
  2 including contents and datafiles;
Table space has been deleted.
     
         
         
         
  More:      
 
- Start Linux ISO image directly from the hard disk (Linux)
- Sort sql MySQL 5.6 upgrade slow Cause Analysis (Database)
- expdp reported ORA-39181 Export Processing Method (Database)
- Linux operation and maintenance of the actual file system, file links (Linux)
- ImportTsv-HBase data import tool (Database)
- System Security: Build Linux with LIDS steel castle (Linux)
- Linux port scanning (Linux)
- Security: set limits on password (Linux)
- BCP importing and exporting large amounts of data Practice (Database)
- Ubuntu install video conversion tool Selene (Linux)
- CUDA (including GPU card driver) installation process under Ubuntu (Linux)
- CentOS 6.4 installation and configuration LNMP build PHP server runtime environment (Server)
- How to use scientific data Docker quickly configure the development environment (Server)
- Why learn Java EE (Programming)
- To setup NOTRACK and TRACK of conntrack in iptables (Linux)
- Basic Operation Linux files and directories (Linux)
- Through Oracle to help restore MySQL data problems (Database)
- Nginx supports user multi-threaded downloads and resume broken (Server)
- Linux disk quota-related instruction (Linux)
- Shell scripts to copy all directories under the current directory of a certain type of file to the same directory (Linux)
     
           
     
  CopyRight 2002-2022 newfreesoft.com, All Rights Reserved.