Home PC Games Linux Windows Database Network Programming Server Mobile  
           
  Home \ Database \ Oracle table space create large files     - Oracle in the add & split partition on the impact of global & local index (Database)

- The Java utility, JavaMail (Programming)

- CentOS environment prepared crontab scheduled tasks (Linux)

- Sshuttle A VPN-based transparent proxy that uses ssh (Server)

- Fedora 8 configured Heartbeat (Linux)

- PXE + Kickstart automatically install CentOS 6.5 (Linux)

- Some Linux networking tools you might not know (Linux)

- Nginx logging client ip (Server)

- Archive log file size and redo log file size relationship (Database)

- Mac OS X command line to submit the local project to Git (Server)

- Shell scripts to copy all directories under the current directory of a certain type of file to the same directory (Linux)

- Boost notes --Thread - problems encountered in the initial use on Ubuntu (Programming)

- JavaScript event handling Detailed (Programming)

- Debian 8.1 (amd64) deployed Memcached (Server)

- File compression and packaging commands under Linux (Linux)

- Spring Integration ehcache annotation implement the query cache and cache update or delete instant (Programming)

- How to monitor network usage by nload in Linux (Linux)

- Linux disk quota-related instruction (Linux)

- Android SDK Manager can not update the domestic solutions (Linux)

- CentOS 6.5 start ActiveMQ being given to solve (Server)

 
         
  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:      
 
- NGINX Plus now fully supports HTTP / 2 (Server)
- To install MySQL on Linux (Database)
- Linux System Getting Started Learning: the local time in between Perl and UNIX timestamp conversion (Linux)
- Oracle 11g maintenance partitions - Adding Partitions (Database)
- Hadoop1.2.1 plug compilation (Server)
- Linux create and delete user step (Linux)
- MySQL stored procedures and triggers (Database)
- Installation Atom text editor on Mint Ubuntu / Linux (Linux)
- SQL statement to repair SQL Server database (Database)
- Installation and Configuration ISC DHCP server on Debian Linux (Server)
- How to Install Puppet in the Ubuntu 15.04 (Server)
- Differential test piece using MongoDB performance YCSB (Database)
- MySQL server after an unexpected power outage can not start (Database)
- Oracle through the alarm log view and inspect the main library, physical and snapshot standby database (Database)
- EXP-00091 Error resolved (Database)
- Spark and Hadoop comparison (Server)
- Linux Workstation Security Checklist - from the Linux Foundation Internal (Linux)
- There is sort of a directed acyclic graph topology (Programming)
- Linux, modify / etc / profile file (Linux)
- Recover Ubuntu 14.04 wakes up from standby in case mouse keyboard appears dead (Linux)
     
           
     
  CopyRight 2002-2022 newfreesoft.com, All Rights Reserved.