Home PC Games Linux Windows Database Network Programming Server Mobile  
           
  Home \ Database \ Oracle table space create large files     - Initialization and starting process of Linux (Linux)

- Android Studio commonly used shortcuts and how to follow the Eclipse Shortcuts (Linux)

- Linux system security reinforcement system by masquerading method (Linux)

- Windows 7 hard disk installation notes Debian (Linux)

- 10 Nginx safety tips (Linux)

- PostgreSQL-XL installation and deployment (Database)

- Oracle 11g maintenance partitions - Adding Partitions (Database)

- ORA-00600 error solve one case (Database)

- OpenGL Superb Learning Notes - New Patterns (Programming)

- Arduino UNO simulation development environment set up and run simulation (Linux)

- Fun music library in Linux using command line (Linux)

- Nginx configuration support f4v video format player (Server)

- Java implementation linear table - represents the order of representation and chain (Programming)

- Linux commands to access the cheat sheet (Linux)

- HTTP and FTP TCP-FLOOD CC Attacks Analysis and Prevention solutions under CentOS 6.5 (Linux)

- Git / Github use notes (Linux)

- Oracle DATABASE LINK (DBLINK) Create (Database)

- OpenVPN offsite interconnecting room availability and load balancing solution (Server)

- Installation JDK 1.8 under CentOS7 (Linux)

- Distributed File System using MogileFS (Linux)

 
         
  Oracle table space create large files
     
  Add Date : 2018-11-21      
         
         
         
  Large table space is Oracle 10g as well as a new type of table space for a future version of the introduction, mainly used for storing large files must Solutions shortage. Different from ordinary table space is large file table space can only correspond to a unique data files or temporary files, and ordinary table space can correspond to a maximum of 1022 data files or temporary files.

Although large table space can only correspond to a data file or temporary file, but the corresponding files up to 4G of data block size, and ordinary table space corresponding to the maximum file size up to 4M data blocks.

Create a large table space

Create a large table space need to use bigfile keywords, and only for a specified data files or temporary files.

With large table space corresponding to the general use of ordinary table space smallfile keyword means, but by default, you can omit the keyword, because this is the default type of table space is created smallfile. You can find out the type of the current database default tablespace by querying the data dictionary database_propertis.

SQL> create bigfile tablespace mybigspace // large table space
  2 datafile 'f: \ oracledata \ bigspace.dbf'
  3 size 10m;
Table space has been created.
SQL> select tablespace_name, bigfile from dba_tablespaces;
TABLESPACE_NAME BIG
------------------------------ ---
SYSTEM NO
SYSAUX NO
UNDOTBS1 NO
TEMP NO
USERS NO
MYTEMP NO
TEMPGROUP NO
TEMPGROUP02 NO
MYBIGSPACE YES
9 has been selected row.


SQL> column property_name format a20
SQL> column property_value format a20
SQL> column description format a30
SQL> select property_name, property_value, description from database_properties where property_name = 'DEFAULT_TBS_TYPE';


PROPERTY_NAME PROPERTY_VALUE DESCRIPTION
-------------------- -------------------- ---------- --------------------
DEFAULT_TBS_TYPE SMALLFILE Default tablespace type
     
         
         
         
  More:      
 
- Chrome plug-in management, online-offline installation, part of the plug presentations (Linux)
- Ubuntu 14.10 installation SecureCRT 7.3 (Linux)
- C language print various graphic (Programming)
- Linux System Getting Started Tutorial: mounted directly in Linux LVM partition (Linux)
- Into the Java keyword instanceof (Programming)
- Linux command binlog by filtering out the complete SQL statement (Database)
- CentOS6 5 Configure SSH password Free (Linux)
- Oracle Execute to Parse perform analytical Ratio Analysis (Database)
- How do you prevent other users from accessing your home directory in Linux (Linux)
- Use 3G wireless network card under Linux (Linux)
- Reported too many open files Linux solutions (Server)
- AngularJS notes --- Scope and controller (Programming)
- How to update the Linux kernel to improve system performance (Linux)
- Unity Greeter Badges: the lost session icon back to the login screen Ubuntu (Linux)
- Simple to install Tor browser to Ubuntu 14.04 and Linux Mint 17 (Linux)
- Linux command execution judge sentences -;, &&, || (Linux)
- Each catalog Detailed Linux (Linux)
- C ++ implementation of the list of basic operations and test cases (Programming)
- Ubuntu method for single-card dual-IP (Linux)
- 10 Best Swift Tutorial examples (Programming)
     
           
     
  CopyRight 2002-2022 newfreesoft.com, All Rights Reserved.