Home PC Games Linux Windows Database Network Programming Server Mobile  
           
  Home \ Database \ Create and modify Oracle temporary table space     - GDB remote connections RX Probe online debug program (Programming)

- Linux + Apache + PHP + Oracle based environment to build (Server)

- Linux run queue process scheduling (Programming)

- Setting Derby as Linux / Windows running as a service from the start (Server)

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

- Android use canvas board painting (Programming)

- Linux scheduling summary (Linux)

- SQL Server automatic backup script (Database)

- Cryptography development environment to build under Ubuntu (Linux)

- jQuery plugin dynamic label generation (Linux)

- On the Web application attack techniques Common (Linux)

- Use Mop monitor stock prices at the Linux command line (Linux)

- How to install Git on CentOS 7 (Linux)

- 64 Ubuntu 15.04 Linux kernel upgrade to Linux 4.1.0 (Linux)

- Common Linux System Troubleshooting (Linux)

- ssh port forwarding Comments (Server)

- Advanced Linux security settings (Linux)

- Getting Started with Linux system to learn: how to install USB webcams come in raspberry (Linux)

- C ++ Supplements - locates the new expression (Programming)

- Linux System Getting Started Learning: The Linux anacron 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:      
 
- Use py2exe to generate exe files Python script (Programming)
- Docker: Mirroring and container operations (Server)
- Spring-depth understanding of the various annotations (Programming)
- grep command output highlighted word (Linux)
- Swift rewrite initialize method of navigation controller class (Programming)
- Selection sort, insertion sort, and Shell sort (Programming)
- Cobbler batch install Ubuntu / CentOS system (Linux)
- Oracle create user authorization and in PLSQL (Database)
- C ++ How to determine the types of constants (Programming)
- Linux Basic Course: Install the software from source code (Linux)
- Spring AOP custom annotation way to achieve log management (Programming)
- Linux System Tutorial: How to Check MariaDB server versions (Database)
- Linux ldconfig command (Linux)
- Dom4j change XML coding (Programming)
- Protobuf compiled and used on the Ubuntu 14.04 (Programming)
- To see the Linux device tree (Linux)
- secureCRT remote login Linux must first open the connection protocol (Linux)
- PostgreSQL query lock and kill the process (Database)
- Linux (Debian) install software, missing dynamic link libraries .so (Linux)
- Linux install Samba file sharing server (Server)
     
           
     
  CopyRight 2002-2020 newfreesoft.com, All Rights Reserved.