Home PC Games Linux Windows Database Network Programming Server Mobile  
           
  Home \ Database \ Oracle table space create large files     - Java development specifications summary (Programming)

- Eclipse-ee Tomcat browser can not start Tomcat, and Web project service deployment (Server)

- ThinkPad X201i installation notes Debian 7.5 (Linux)

- Linux System Getting Started Learning: Join cron job in Linux (Linux)

- Linux, C programming language library file handling and preparation of Makefile (Programming)

- Linux command in the dialog whiptail (Linux)

- Installation GitLab appears ruby_block supervise_redis_sleep action run (Linux)

- How to use GRUB2 files directly from the hard disk to run ISO (Linux)

- Python image processing library (PIL) to install and simple to use (Linux)

- Distributed transaction management Spring declarative transactions (Programming)

- RedHat Performance Tuning (Server)

- How to view the Linux QPS (Linux)

- How to update the Linux kernel to improve system performance (Linux)

- Configuring Haproxy log support (syslog logging support) (Server)

- Git uses a small mind (Linux)

- Use backup-manager system backup on Linux (Linux)

- Ubuntu 14.10 / 14.04 how to install Quick Start tool Mutate 2.2 (Linux)

- ORA-38856: Unable instance UNNAMED_INSTANCE_2 (redo thread 2) marked enabled (Database)

- Linux firewall anti-hacker disguise malicious attacks (Linux)

- Linux command to view the system status (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:      
 
- Oracle inline view updates problems encountered (Database)
- CentOS 7 Change Hostname (Linux)
- MySQL view (Database)
- Java garbage collection and heap memory layout (Programming)
- Java Concurrency -volatile keywords (Programming)
- What factors affect the performance of Java calls (Programming)
- How to enable curl command HTTP2 support (Linux)
- Some practical tips Linux (Linux)
- Relationship between Linux permissions with the command (Linux)
- Android child thread really do not update UI (Programming)
- Java regular expression syntax (Programming)
- iptraf: A Practical TCP / UDP network monitoring tools (Linux)
- Ubuntu comes with gedit editor to add Markdown preview widget (Linux)
- Android custom ViewPager create kaleidoscopic image transition effects (Programming)
- Linux with Windows Explorer as a security system (Linux)
- Linux suffered SYN flood attack setting (Linux)
- MySQL partition table Comments (Database)
- DB2 manually create a library (Database)
- Linux system started to learn: how to view the Linux thread of a process (Linux)
- Android imageView in the Src and Background (Programming)
     
           
     
  CopyRight 2002-2022 newfreesoft.com, All Rights Reserved.