Home PC Games Linux Windows Database Network Programming Server Mobile  
           
  Home \ Database \ Oracle table space rename and delete table space     - Linux centos rm directory does not prompt (Linux)

- Linux operating system to solve a serious fault handling (Linux)

- phpinfo (): like phpinfo as a Python script (Programming)

- Cygwin install Python MySQLdb (Linux)

- C / C ++ language usage summary of const (Programming)

- Linux system security settings (Linux)

- Monitoring services are running properly and will email alert (Server)

- Ubuntu 15.04 and Ubuntu 14.04 installed Cinnamon 2.6 (Linux)

- Erlang concurrency and foundation (Programming)

- MongoDB data replication and data slices (Database)

- When a software RAID data recovery and reconstruction of how failure (Linux)

- ElasticSearch - Basic Concepts (Server)

- Android screen rotation processing and ProgressDialog the best AsyncTask (Programming)

- Wireless LAN security solutions (Linux)

- CentOS / Linux restart active NIC connection paths / network configure error Error Resolution (Linux)

- installation and configuration of the PHP environment (Apache2) under Linux (Server)

- Oracle archive log full cause abnormal slow database performance (Database)

- HomeKit Human Interface Guidelines (Linux)

- iOS constants, variables, properties and characteristics (Programming)

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

 
         
  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:      
 
- Use MD5 transform algorithm to prevent exhaustive decipher passwords (Linux)
- Ubuntu deployment Flask + UWSGI + Nginx Comments (Server)
- Docker build their own private warehouses (Linux)
- How Vim playing a mature IDE (Linux)
- Android Scroller call mechanism and the relationship of computeScroll (Programming)
- The ORA-01113 error is handled with BBED without archiving (Database)
- Linux Apache server security (Linux)
- How to use GRUB2 files directly from the hard disk to run ISO (Linux)
- How to set up HTTPS policies for older browsers (Server)
- Linux Network Programming - raw socket programming (Programming)
- React Native (Programming)
- Security Configuration SQL Server 2000 database tutorial (Linux)
- Denyhosts prevent hackers using SSH scanning (Linux)
- for (int a: i) the use of the Java programming (Programming)
- Security enhancements in Ubuntu ssh service (Linux)
- Hanoi problem Java Solution (Programming)
- MySQL password on those things you should know (Database)
- Mac OS X 10.10 Yosemite compiling OpenJDK 9 (Linux)
- Install apr support for Tomcat on Linux (Server)
- Installation through the network Debian 7 (Wheezy) (Linux)
     
           
     
  CopyRight 2002-2022 newfreesoft.com, All Rights Reserved.