Home PC Games Linux Windows Database Network Programming Server Mobile  
           
  Home \ Database \ Oracle create a temporary table space group     - Rely on IP chain established Linux firewall (Linux)

- RVM installation instructions (Linux)

- Linux System Tutorial: Ubuntu on the desktop is disabled by default keyring to unlock tips (Linux)

- Linux and SELinux Exploration Program Manager (Linux)

- 20 Linux commands interview questions and answers (Linux)

- Ubuntu install perfectly handsome terminal Guake 0.8.1 (Linux)

- systemd Power Management (Linux)

- Linux account management add relevant directives (Linux)

- Install Java on RHEL6 (Linux)

- Binary tree traversal: the first sequence in order preorder recursive and non-recursive and traversal sequence (Programming)

- Ubuntu Install OpenSSL (Linux)

- Compile and install Memcached can not find GCC (Programming)

- Cool Android realization SVG animation (Programming)

- LaTeX Getting Started Tutorial (Linux)

- Nine artifact control disk partition under Linux (Linux)

- Role Object of registerNatives () method (Programming)

- Examples of testing and installation Mesos on CentOS (Linux)

- PL / SQL how to make the program every few seconds to insert a data (Database)

- Fedora 19/20 and Debian Jessie / Sid users to install FFmpeg 2.3.2 (Linux)

- Install NetBeans IDE 8.0 on Ubuntu, Linux Mint, Elementary OS, and Debian (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:      
 
- Processor in protected mode of protection (Linux)
- C ++ Supplements --new delete overload (Programming)
- CentOS 6 kernel upgrade to Kernel 3.x (Linux)
- Linux and SELinux Exploration Program Manager (Linux)
- Linux Shell Understanding and Learning (Linux)
- CentOS install Redis (Database)
- Oracle multi-table query optimization (Database)
- Use OpenWrt build WDS wireless network extension on V2 WHR-G300N (Linux)
- SUSE Linux install Oracle 10g and problem solving (Linux)
- Ubuntu Install OpenSSL (Linux)
- To install Oracle Database Details and FAQ Summary under CentOS (Database)
- Drawing from the Android source code analysis View (Programming)
- The most concise explanation of JavaScript closures (Programming)
- DB2 table space is redirected to restore the database combat (Database)
- Using Java arrays implement sequential stack (Programming)
- Use Epoll develop high-performance application server on Linux (Server)
- Linux systems for entry-learning - Install Go language in Linux (Linux)
- Android annotation support (Support Annotations) (Programming)
- Linux in order to make NMAP hide and seek with the firewall (Linux)
- Shell command line operation (Linux)
     
           
     
  CopyRight 2002-2022 newfreesoft.com, All Rights Reserved.