ORA-03206: oracle 11g maximum table space size [turn]

2010-11-15  来源:本站原创  分类:Database  人气:191 

Transfer: http://www.360doc.com/content/10/0712/09/1265417_38411103.shtml

Unfortunately, you encountered a difficult problem encountered. Unfortunately, you must be edgy. People can encounter this error is not an ordinary person. So you must not a mortal, you are special.

Oh, and you do not joke. Now analyze the problem.

oracle support his db_block_size file size and the number and db_block decision. Before the oracle 9i, oracle maximum number of db_block only 2 of the 22 th power, but oracle default template we built a database instance db_block_size is 8K. So oracle 9i supports single file before the default size is 32GB. Although there is no such restriction oracle 11g, but it is so much the default capacity. So I said before if you encounter this problem to show that you are not most people, you create a single file more than 32GB of table space.

So how to solve this problem, I am here to provide three reference program, you use choose the right one for you, Oh:

A) Do not create a single file over 32GB table space

If you create a table space more than 32GB, please put this table space is stored as multiple data files, each no larger than 32GB. In this way, you can successfully create the table space.

B) expand the db_block_size

According to the oracle of the algorithm, we can easily think of this solution. A constant number, but you can change db_block_size (db_block_size the maximum size of 32KB). If db_block_size expanded to 32KB (32-bit systems like 16KB, my Red Hat Enterprise Linux operating system to create the block_size 32KB failure.), Then our system to support a single data file can be maximum 128GB.

This program sounds like a very charming, but not actually the case. Because you want to modify db_block_size not very easy. Because of this, when you create an instance db_block_size must be specified. And can not be modified by a simple parameter to specify db_block_size. Create an instance of a larger database of db_block_size I will speak later.

C) create bigfile tablespace

The introduction of a bigfile in oracle11g table space, he takes full advantage of 64-bit CPU's addressing capabilities to enable oracle to manage data files total to 8EB. Single data file size to 128TB, even if the default 8K of db_block_size reached 32TB.

Create bigfile tablespace using sql statement is simple.

create bigfile tablespace ...

Behind the statements and general statements the same.

Note that using bigfile table space, he can only support a data file. That is the maximum file size is the maximum size of table space, you can not file by adding data to expand the size of table space. So oracle, if you file no space left, you still do not use bigfile table space, this table space you do not have room for expansion, and Oh.

oracle also tell you, I suggest you use lvm or other software management disk, so you can dynamically expand the space. Oh, first mentioned here, if there do not understand, please let me know.

http://www.blogjava.net/decode360/archive/2009/08/27/292754.html

There are also instructions.

相关文章
  • ORA-03206: oracle 11g maximum table space size [turn] 2010-11-15

    Transfer: http://www.360doc.com/content/10/0712/09/1265417_38411103.shtml Unfortunately, you encountered a difficult problem encountered. Unfortunately, you must be edgy. People can encounter this error is not an ordinary person. So you must not a mo

  • ORA-03206: oracle 11g maximum table space size [transfer] 2010-11-15

    Transfer from: http://www.360doc.com/content/10/0712/09/1265417_38411103.shtml Unfortunately, you encountered a difficult problem encountered. Unfortunately, that you're edgy. Who can encounter this error is not an ordinary person. Then you must not

  • Oracle Database Notes - Table space 2011-01-07

    In the previous study and Oracle database infrastructure, it is already understand Oracle's memory structure, logic, Oracle's data stored in the tablespaces, the physically stored in the datafiles in. A tablespace can only belong to a database (a dat

  • ORACLE temporary segment table space, modify the table space 2011-01-13

    Issue a ORA-01652:unable to extend temp segment by num in tablespace name ORA-01652:unable to extend temp segment by num in tablespace name Causes :ORACLE Temporary segment table space, because ORACLE Always try to allocate contiguous space, one can

  • Oracle Create User Table space import and export command (turn) 2011-06-21

    / / Create a temporary table space create temporary tablespace test_temp tempfile 'E: \ oracle \ product \ 10.2.0 \ oradata \ testserver \ test_temp01.dbf' size 32m autoextend on next 32m maxsize 2048m extent management local; / / Create a data table

  • window, linux, create oracle user and table space is easy to learn compared 2010-05-26

    1, window to create oracle user and table space - Create a data table space create tablespace oras_data - table space name logging datafile 'D: \ oracle \ product \ 10.1.0 \ oradata \ oras_data.dbf' - table space file, note the database version is 10

  • oracle 9i temporary table space 2010-03-04

    Taken from: http://hi.baidu.com/zzztou/blog/item/f8733707008383c87b8947b3.html Normally, the complete Select statement, create index using the TEMP table space and some sort is done, Oracle will automatically release the temporary section of a swap o

  • oracle imp the table space when you import and export 2010-10-13

    <Transfer from: http://asword.itpub.net/post/7923/231847> IMP authority on the user by a DBA EXP data, the data storage table space several situations (IMP-00013) -1 ORACLE Corporation to train BIEE, with a DEMO of the DMP file, which exported the u

  • Oracle creates the table space and user 2010-04-08

    Software engineers sometimes must be the database administrator, this is not, do not come down, and create the database. - Create temporary table space CREATE TEMPORARY TABLESPACE test_temp TEMPFILE 'D: \ ORACLE \ PRODUCT \ 10.2.0 \ ORADATA \ ORCL \

  • Oracle Note 2 - Table space 2010-06-06

    Table space 1. Tablespace Category: 1) the user table space (most common) 2) temporary table space (temporary) 3) Restore the table space (undo) A. create a user table space Syntax: CREATE TABLESPACE MYSPACE # create a table space named MYSPACE DATAF

  • a create a user oracle. create a table space. authorized. the whole process of building the table 2010-12-21

    1. First, we can use scott as sysdba user to log in oracle. conn scott/tiger as sysdba 2. Since then I can create the user. create user zzg identified by zzg123; 3. We created the user can then modify the user's password. alter user zzg identified by

  • Oracle create user. Table space. Import and Export command .... 2011-01-12

    / / Create a temporary table space create temporary tablespace test_temp tempfile 'E: \ oracle \ product \ 10.2.0 \ oradata \ testserver \ test_temp01.dbf' size 32m autoextend on next 32m maxsize 2048m extent management local; / / Create a data table

  • Oracle Create User Table space import and export commands .... 2011-07-18

    / / Create a temporary table space create temporary tablespace test_temp tempfile 'E: \ oracle \ product \ 10.2.0 \ oradata \ testserver \ test_temp01.dbf' size 32m autoextend on next 32m maxsize 2048m extent management local; / / Create a data table

  • oracle database create table space, user, authorization, import and export dmp 2011-07-29

    / / Create a temporary table space create temporary tablespace zfmi_temp tempfile 'D: \ oracle \ oradata \ zfmi \ zfmi_temp.dbf' size 32m autoextend on next 32m maxsize 2048m extent management local; / / Tempfile parameters must be / / Create a data

  • oracle 10g create table space to create the user. to change the users default tablespace. delete the temporary table space 2010-08-28

    Create temporary table space create temporary tablespace stbss_tmp tempfile 'E:\oracle\product\10.2.0\oradata\orcl\stbss_temp01.dbf' size 32m autoextend on next 32m maxsize 2048m extent management local; Create table space create tablespace stbss log

  • The Oracle architecture - database table space instances Introduction 2010-10-29

    First, the database Database suggests that it is a collection of data, but Oracle is the management of these data collection software system, it is an object-relational database management system. Second, the table space Oracle table space is related

  • Oracle Create User Table space import and export 2010-11-17

    Oracle create user, tablespace, import and export / / Create a temporary table space create temporary tablespace temptablespacename tempfile 'E: \ oracle \ product \ 10.2.0 \ oradata \ testserver \ temptablespace01.dbf' size 32m autoextend on next 32

  • create a user oracle Create the table space authorization process to build a complete table 2010-12-21

    1 First, we can use the scott user logged on as sysdba oracle. conn scott/tiger as sysdba 2. Since then I can create users. create user zzg identified by zzg123; 3 We then created the user can modify the user's password. alter user zzg identified by

  • create user oracle Create the table space and specify user privileges 2010-12-22

    SYS user in the CMD, the DBA login: 1 in the CMD in the fight sqlplus / nolog 2 then SQL> conn / as sysdba Show successful connection ... 3 Create a temporary table space SQL> create temporary tablespace user_temp tempfile 'D: \ oracle \ oradata \ O

  • Oracle Temp temporary table space handling 2011-05-01

    Temporary tablespace is the oracle in the temporary table space, temporary table space in the main use is to sort the database operations, management, indexing, access to views and other operating room to provide temporary operation, when operation i