Home PC Games Linux Windows Database Network Programming Server Mobile  
           
  Home \ Database \ Create and modify Oracle temporary table space     - Single list summarizes the basic operation (Programming)

- Delay for the specified IP port analog network to send and receive packets on Linux (Linux)

- Linux, grep, sed usage (Linux)

- tcpdump Linux system security tools (Linux)

- 6 common PHP security attacks (Linux)

- Android Studio Personalization (Linux)

- S5PV210 development board for embedded development environment to build under Ubuntu (Linux)

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

- RabbitMQ tutorial examples: the Hello RabbitMQ World Java realization (Linux)

- Parameters of the extra port MySQL 5.6 (Database)

- Java implementation file encryption and decryption (Programming)

- Ubuntu 15.04 install Complete Guide (Linux)

- Linux, modify the hostname (Linux)

- IronPython and C # to interact (Programming)

- How to use the DM-Crypt encryption Linux File System (Linux)

- Use the vi text editor and copy and paste Linux tips (Linux)

- How to use Quagga BGP (Border Gateway Protocol) router to filter BGP routing (Linux)

- ARM assembler instruction debugging method (Programming)

- Linux argument references and command substitution (Linux)

- Linux development management utility command (Linux)

 
         
  Create and modify Oracle temporary table space
     
  Add Date : 2018-11-21      
         
         
         
  Table space is a temporary disk space used primarily to store a user execute order by interim statements lamp sort data generated or aggregated. By default, all users are using temp as the default temporary table space. But allows the use of other temporary tablespace as the default temporary table space, which needs to be specified when creating the user.

Create a temporary table space is required to use temprary keyword and the corresponding temporary table space is a temporary file, specified by the tempfile keyword, that is, the temporary table space is no longer used in the data file, but with temporary files.

As follows:
SQL> create temporary tablespace mytemp tempfile 'f: \ Oracledata \ mytemp.dbf' size 5m autoextend on next 2m maxsize 20m;

Table space has been created.
At this point in the directory f oracledata disk files can be found mytemp.dbf
SQL> select tablespace_name, status from dba_tablespaces;

TABLESPACE_NAME STATUS
------------------------------ ---------
SYSTEM ONLINE
SYSAUX ONLINE
UNDOTBS1 ONLINE
TEMP ONLINE
USERS ONLINE
TEMPGROUP ONLINE
TEMPGROUP02 ONLINE
MYBIGSPACE ONLINE
BLOCKSPACE ONLINE
INSPUR ONLINE
TESTSPACE ONLINE
TEST ONLINE

MYTEMP ONLINE

Line 12 has been selected.

In this case we can find MYTEMP table space table space.

Modify the temporary table space
After you create a temporary table space, you can modify the table space. Since the temporary file does not store temporary data during operation permanent data storage sorting knowledge generated, and create after the operation, the data stored in the temporary files deleted by the user in the system, so under normal circumstances do not need to adjust the temporary table space. But when multiple users, especially the art of war, and the operation is more complicated, may be insufficient temporary table space occur. In this case, the administrator can add temporary data files to increase the temporary table space.
If you need to increase or decrease the temporary file, you can use the add tempfile clause.
If you need to modify the size of the temporary file, you can use the resize keyword.
You can also change the temporary status of offline or online.

SQL> select file #, status, name from v $ tempfile;


    FILE # STATUS NAME
-------------------------------------------------- ---------------------------------------------
        1 ONLINE D: \ ORACLE \ ORADATA \ ORACLE12C \ TEMP01.DBF
        2 ONLINE D: \ ORACLE \ ORADATA \ ORACLE12C \ PDBSEED \ PDBSEED_TEMP012015-01-03_05-20-33-PM.DBF
        3 ONLINE D: \ ORACLE \ ORADATA \ ORACLE12C \ PDBORCL \ PDBORCL_TEMP012015-01-03_05-44-35-PM.DBF
        4 ONLINE F: \ ORACLEDATA \ MYTEMP.DBF
        6 ONLINE F: \ ORACLEDATA \ TEMPGROUP01.DBF
        7 ONLINE F: \ ORACLEDATA \ TEMPGROUP02.DBF


Selected 6 rows.

SQL> alter tablespace mytemp add tempfile 'f: \ oracledata \ mytemp2.dbf' size 10m;

Table space has changed.

SQL> select file #, status, name from v $ tempfile;


    FILE # STATUS NAME
-------------------------------------------------- --------------------------------------------
        1 ONLINE D: \ ORACLE \ ORADATA \ ORACLE12C \ TEMP01.DBF
        2 ONLINE D: \ ORACLE \ ORADATA \ ORACLE12C \ PDBSEED \ PDBSEED_TEMP012015-01-03_05-20-33-PM.DBF
        3 ONLINE D: \ ORACLE \ ORADATA \ ORACLE12C \ PDBORCL \ PDBORCL_TEMP012015-01-03_05-44-35-PM.DBF
        4 ONLINE F: \ ORACLEDATA \ MYTEMP.DBF
        5 ONLINE F: \ ORACLEDATA \ MYTEMP2.DBF
        6 ONLINE F: \ ORACLEDATA \ TEMPGROUP01.DBF
        7 ONLINE F: \ ORACLEDATA \ TEMPGROUP02.DBF

As indicated above, f disk oracledata folder created under a file mytemp2.dbf
     
         
         
         
  More:      
 
- Let CentOS6 yum upgrade to support more source rpm package (Linux)
- Ubuntu 14.04 Nvidia proprietary drivers for install two graphic cards (Linux)
- Cacti installation deployment under CentOS 6.6 (Server)
- vnStatSVG: traffic monitoring software vnStat (Linux)
- Getting the Linux shell flow control statements (Programming)
- Linux, modify / retrieve the root password (Linux)
- Linux vi command list (Linux)
- Oracle how to assess the true concurrent session (Database)
- Linux Powerful IDE - Geany configuration instructions (Linux)
- Python system default encoding (Programming)
- Use virt-manager to create and manage virtual machines (Linux)
- The most simple drive to write and test procedures under linux (Programming)
- Oracle TDE transparent data encryption (Database)
- RMAN parameters of ARCHIVELOG DELETION (Database)
- Quick Install software RAID on Linux (Linux)
- Java Collections Framework interfaces map (Programming)
- Python2.7.7 source code analysis (Programming)
- Analyzing Linux server architecture is 32-bit / 64-bit (Server)
- Oracle common internal event tracking number (Database)
- Iptables application layer plug (Linux)
     
           
     
  CopyRight 2002-2020 newfreesoft.com, All Rights Reserved.