Home PC Games Linux Windows Database Network Programming Server Mobile  
           
  Home \ Database \ Create and modify Oracle temporary table space     - KVM add virtual disks (Linux)

- CentOS7 installed MySQL (Database)

- Hadoop connection failed or stuck processing (Server)

- Linux system performance tuning of Analysis (Linux)

- Setting Hibernate connection MySQL database connection pool coding (Database)

- Puppet 3.5 Source package Installation and Configuration (Server)

- Usage logs Python library (Programming)

- PostgreSQL transaction model introduction (Database)

- How to install the Linux text editor Atom 0.124.0 (Linux)

- Linux installation and error under codeblocks exclude [Ubuntu 10.04] (Linux)

- C ++, overloading, cover, hide (Programming)

- Ubuntu font settings: Using Windows Font (Linux)

- Upgrading Oracle 11.2.0.1 to 11.2.0.3 (Database)

- Linux MultiPath software implementation instructions (Linux)

- Oracle table space rename and delete table space (Database)

- Android in the event delivery and handling mechanism (Programming)

- Docker container plaintext password problem-solving way (Server)

- Linux system security infrastructure Highlights (Linux)

- MariaDB database storage path modify configuration issues (Database)

- Linux Fundamentals of the text, data flow processing orders (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:      
 
- Using DBMS_STAT function closes mission (Database)
- Linux file content inspection - cat, tac, no, more, less, head, tail, od (Linux)
- MySQL can not write the data keyword conflicts (Database)
- Linux environment Duplex (multi-machine) automatic mutual backup scheme (Linux)
- Java object serialization (Programming)
- DRBD switchover (Server)
- MySQL use the integer type (Database)
- Java memory model subclasses (Programming)
- Some Linux networking tools you might not know (Linux)
- Kibana use installation (Linux)
- Swift defined type conversion and type aliases (typealias) (Programming)
- MySQL use benchmarking tool sysbench (Database)
- How open source code libraries hosted on Github (Linux)
- OpenCV 3.0 + Python 2.7 installation and testing under Ubuntu 14.04 (Linux)
- Git bulk delete remote tag (Linux)
- PHP generates a random password several ways (Programming)
- WEB-based Android Remote Tools Python implementation (Programming)
- ORA-00845: MEMORY_TARGET not supported on this system Problem (Database)
- Linux / Unix desktops interesting: Christmas tree on the terminal (Linux)
- Linux virtual machine how to access the Internet in a virtual machine when using NAT mode (Linux)
     
           
     
  CopyRight 2002-2022 newfreesoft.com, All Rights Reserved.