Home PC Games Linux Windows Database Network Programming Server Mobile  
  Home \ Database \ Oracle table space create large files     - 4 lvcreate example commonly used commands (Linux)

- Git / Github use notes (Linux)

- Linux systems for entry-learning - Install Go language in Linux (Linux)

- Ubuntu 14.10 / 14.04 / 12.04 virtual users to install the printing software Boomaga (Linux)

- How to protect your eyes automatically adjust the screen brightness on Linux (Linux)

- Apache POI Excel Document Processing (Linux)

- To convert into a binary search tree sorted doubly linked list (Programming)

- Android design patterns - state mode (Programming)

- Customize the output format in Linux history (Linux)

- Oracle () trunc function usage (Database)

- Analysis: Little Notebook facing a major security threat secure online (Linux)

- Linux System Tutorial: How to browse the Linux command line, weather forecast (Linux)

- Linux NIC configuration (Linux)

- SecureCRT 7.0 Log Ubuntu 12.04 server via SSH service under Vmware (Server)

- GAMIT 10.50 installed in Ubuntu 12.04 system (Linux)

- Android Touch message passing mechanism analysis (Programming)

- Valgrind * not * leak check tool (Linux)

- quotacheck command file can not be created aquota.user and aquota.group solutions (Linux)

- Ubuntu 15.10 / 14.04 install subtitling software Aegisub (Linux)

- Docker build their own private warehouses (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;
------------------------------ ---
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';

-------------------- -------------------- ---------- --------------------
DEFAULT_TBS_TYPE SMALLFILE Default tablespace type
- Openfire achieve load balancing cluster by Nginx (Server)
- Understanding and Memcached MongoDB arbitration node, Zookeeper, Redis Recovery Programme Thoughts (Database)
- Linux input and output redirection (Linux)
- Oracle 11g on Linux system boot from the startup settings (Database)
- Django 1.8 TEMPLATE_DIRS configuration and STATICFILES_DIRS (Server)
- Oracle 11g + RAC + RHEL6.5 + udev + ASM + PSU installation summary (Database)
- Linux network monitoring strategy (Linux)
- Linux reserves the rest of the file to delete several (Linux)
- The basic principles of AIX system security (Linux)
- Ubuntu 14.04 compile, install, configure, the latest development version GoldenDict (Linux)
- PHP interview questions of design patterns (Programming)
- MongoDB configuration in Ubuntu 14.04 (Database)
- Oracle background processes daemons (Database)
- Sleuth Kit: used to analyze a disk image and restore files open source forensics tools (Linux)
- Glibc support encryption by modifying the DNS (Programming)
- CentOS 5.5 install ntop (Linux)
- Oracle set the timer task JOB scheduler to execute stored procedures or PL / SQL code block (Database)
- MariaDB 10.0.X, the dynamic column support JSON format to obtain data (Database)
- OpenWrt modify flash size (Linux)
- CentOS install video converter FFmpeg and cutting tools segmenter (Linux)
  CopyRight 2002-2022 newfreesoft.com, All Rights Reserved.