Home PC Games Linux Windows Database Network Programming Server Mobile  
           
  Home \ Database \ Oracle table space rename and delete table space     - How SSHfs mount a remote file system on Linux (Linux)

- MySQL Study of --Percona Server 5.5 Upgrade 5.6 (Database)

- Ubuntu 10.10 install Oracle 10g graphic tutorials (Database)

- Three details reflect the Unix system security (Linux)

- Automated Password Generator: Linux under a special password generator (Linux)

- Install KVM on Ubuntu and build a virtual environment (Linux)

- Linux how to view the graphics models notebook (Linux)

- CentOS / Debian configuration Gitlab 7.1x to build self Git repository (Linux)

- Compare Dalvik virtual machine and the JVM (Linux)

- Present Situation and Development Trend of firewall products (Linux)

- ORA-00824: can not set sga_target due to existing problem-solving (Database)

- The top command under Linux (Linux)

- JSON data normalization (normalize) (Programming)

- Ubuntu font settings: Using Windows Font (Linux)

- Oracle and MySQL difference between the jdbc (Database)

- Stucts2 values on the page and how the attribute values corresponding to the Action (Programming)

- Linux System Getting Started Learning: Linux how to install 7zip (Linux)

- Locale files under Ubuntu (Linux)

- Xshell upload files to achieve Windows host Linux (Linux)

- Linux iptables firewall and vsftpd to resolve the issue (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:      
 
- The method of CentOS-7.0. The installation and configuration of Tomcat-7 (Server)
- Quota for Vsftpd do use disk quotas (Server)
- Oracle Standby Redo Log experiment (Database)
- Redis 3.0.3 Cluster Setup (Database)
- Talk Packages (Linux)
- Oracle PL / SQL selective basis (IF CASE), (LOOP WHILE FOR) (Database)
- Linux Creating a new user error Creating mailbox file: File exists (Linux)
- Build your own Python coding environment (Linux)
- Java heap (Heap) and stack difference (Programming)
- 64-bit Ubuntu 15.10 How to compile the latest version of the 32 Wine 1.7.53 (Linux)
- 24 Docker recommendations (Linux)
- CentOS 6.4 compiler installed MySQL 5.6.14 (Database)
- Efficient running Linux virtual machine Six Tips (Linux)
- The Linux firewall is configured to use proxy (Linux)
- How to install and configure a VNC server on CentOS 7.0 (Server)
- Binding multiple network cards in Linux using command nmcli (Linux)
- Java-based data source database access (Programming)
- Transplant spider to MySQL 5.6 (Database)
- vnStatSVG: traffic monitoring software vnStat (Linux)
- Nginx Load Balancing (standby) + Keepalived (Server)
     
           
     
  CopyRight 2002-2022 newfreesoft.com, All Rights Reserved.