Home PC Games Linux Windows Database Network Programming Server Mobile  
           
  Home \ Database \ Oracle create a temporary table space group     - Oracle 11g + RAC + RHEL6.5 + udev + ASM + PSU installation summary (Database)

- namespace mechanism Linux kernel analysis (Linux)

- PostgreSQL 9.3.2 Json type of use (Database)

- RedHat Linux 6.4 install Oracle 10g error (Database)

- APT-GET commonly used Linux command (Linux)

- MySQL optimization resulting order by using filesort (Database)

- Attic-- delete duplicate data backup program (Linux)

- Spring multi data source configuration (Programming)

- Ubuntu 12.04 install RTL8723BE wireless network card driver (Programming)

- Upgrading Oracle 11.2.0.1 to 11.2.0.3 (Database)

- Linux System Getting Started Learning: Repair fatal error openssl aes h no such file or directory (Linux)

- Shell Scripting Basics (Linux)

- Linux System Administrator common interview questions and answers 30 (Linux)

- Flask installation environment (Linux)

- Java inheritance initialization problem (Programming)

- MongoDB 3.2 Cluster Setup (Database)

- How to upgrade the kernel to 3.13.7 on Ubuntu / Linux Mint (Linux)

- ORA-4031 error Solution (Database)

- How to use SVN to manage our source code (Server)

- Linux regex awk Comments (Linux)

 
         
  Oracle create a temporary table space group
     
  Add Date : 2018-11-21      
         
         
         
  In Oracle 11g later, the user can create a temporary table space group, a group of temporary table space can contain one or more temporary table spaces.
Temporary tablespace group must consist of at least a temporary tablespaces, and no clear maximum limit on the number.
If you remove all the members of a temporary table space group, the group is also automatically deleted.
The name of the temporary table space is not the same as the name of the temporary tablespace group.
Assigned to the user in a temporary table space, temporary table space can use the name instead of the actual group of temporary table space name; when allocated to the database default temporary table space, you can also use the name of the temporary table space group.
Temporary table space group
Create a temporary table space group
Temporary tablespace group does not require specially created, just you need to create a temporary table space,
Use teblespace group statement assigned to a group.


View the temporary table space group information.
Data Dictionary dba_tablespace_grops


Mobile temporary table space
Use alter tablespace statement


SQL> create temporary tablespace tempgroup
  2 tempfile 'f: \ oracledata \ tempgroup01.dbf' size 5m
  3 tablespace group group01;
Table space has been created.
SQL> select * from dba_tablespace_groups;
GROUP_NAME TABLESPACE_NAME
------------------------------ -------------------- ----------
GROUP01 TEMPGROUP


SQL> create temporary tablespace tempgroup02
  2 tempfile 'f: \ oracledata \ tempgroup02.dbf' size 5m
  3 tablespace group group02;
Table space has been created.
SQL> select * from dba_tablespace_groups;
GROUP_NAME TABLESPACE_NAME
------------------------------ -------------------- ----------
GROUP01 TEMPGROUP
GROUP02 TEMPGROUP02


SQL> alter tablespace tempgroup tablespace group group02;
Table space has changed.
SQL> select * from dba_tablespace_groups;
GROUP_NAME TABLESPACE_NAME
------------------------------ -------------------- ----------
GROUP02 TEMPGROUP
GROUP02 TEMPGROUP02
     
         
         
         
  More:      
 
- PostgreSQL Stream Configuration (Database)
- Oracle Database High-Risk Vulnerability Warning (Database)
- Ubuntu U disk do not have write privileges can only read but not write (Linux)
- To setup a ftp server under Linux (Server)
- Add local search to your Android app (Programming)
- Update GAMIT10.6 command (Linux)
- Several start-up mode of Tomcat (Server)
- Install minimize RHEL / CentOS 7 some things need to do (Linux)
- Cryptography development environment to build under Ubuntu (Linux)
- Android Custom View step (Programming)
- Linux system security (Linux)
- Build Nginx + uWSGI + Flask operating environment under CentOS 6.4 tutorial (Server)
- RMAN backup file is much larger than the size of the database Cause Analysis (Database)
- To install file manager Nautilus 3.12.2 under ubuntu (Linux)
- [Errno 4] IOError: [Errno ftp error] with yum appears as a workaround (Linux)
- Type Linux commands (Linux)
- Depth understanding of the TCP protocol (Database)
- Compare Swift achieve rapid sorting and sorted Methods (Programming)
- MySQL + Corosync + Pacemaker + DRBD build highly available MySQL (Server)
- Inxi: Get Linux system and hardware information (Linux)
     
           
     
  CopyRight 2002-2022 newfreesoft.com, All Rights Reserved.