Home PC Games Linux Windows Database Network Programming Server Mobile  
           
  Home \ Database \ Oracle create a temporary table space group     - Ubuntu 14.04 installed NVIDIA graphics driver (Linux)

- Install RAID 6 (Striping double distributed parity) (Linux)

- RedHat / CentOS ext4 partition can not be formatted large supplementary ext4 formatting (Linux)

- Struts2 : combobox label use (Programming)

- Git Installation and Configuration (Network Agent settings) (Linux)

- Hadoop 2.6.0 stand-alone / pseudo-distributed installation (Server)

- CentOS install pip (Linux)

- Ubuntu Gnome and Fedora 22 Gnome desktop, extended to achieve global menu (Linux)

- How do I use Linux development environment (Linux)

- PostgreSQL with the C Completing the storage process instances (Database)

- JavaScript function closures Quick Start (Programming)

- Shell Scripting Basics (Linux)

- Shell script to crawl through AWR SQL Report Problems (Database)

- How to compile and install wxWidgets in Ubuntu / Debian / Linux Mint (Linux)

- Node.js installed on Ubuntu Upstream version (Linux)

- Bootable ISO image using GRUB (Linux)

- Android application security of data transmission security (Programming)

- Use NTFS-3G to mount NTFS partitions under Linux U disk and removable hard disk (Linux)

- Android project using the command to create and install the package (Programming)

- How to clean up your Ubuntu 14.10 / 14.04 / 13.10 system (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:      
 
- Intrusion prevention network server security maintenance tips (Linux)
- RPM package management tools under Linux (Linux)
- Use netcat [nc] command on Linux and Unix port scan (Server)
- Let the router be your security barrier against external attack (Linux)
- To use iostat display I / O status under Linux (Linux)
- JDK tools jstat (Linux)
- Node.js Getting the basics: Helloworld! (Linux)
- MySQL multi-master multi-cluster deployment uses alive Galera (Database)
- How to create a someone project on github (Linux)
- Ubuntu buffalo wzr-hp-300nh brush DD-WRT router system (Linux)
- awk variables (Linux)
- RabbitMQ tutorial examples: the Hello RabbitMQ World Java realization (Linux)
- MultiWriter: while the ISO image concurrent writes 20 USB Startup Disk (Linux)
- Linux iptables port mapping settings (Server)
- Ubuntu install OpenMPI (Linux)
- Oracle database import and export (Database)
- Use Hexo quickly build and deploy a blog to Github (Server)
- Different between Linux file path and the windows (Linux)
- Oracle 12CIN-memory in table spaces (Database)
- CentOS 7.1 install NTFS-3G (Linux)
     
           
     
  CopyRight 2002-2022 newfreesoft.com, All Rights Reserved.