The following example creates a tablespace with uniform 128K extents. (In a database
with 2K blocks, each extent would be equivalent to 64 database blocks). Each 128K
extent is represented by a bit in the extent bitmap for this file.
CREATE TABLESPACE lmtbsb DATAFILE '/u02/oracle/data/lmtbsb01.dbf' SIZE 50M
EXTENT MANAGEMENT LOCAL UNIFORM SIZE 128K;
You cannot specify the DEFAULT storage clause, MINIMUM EXTENT, or TEMPORARY
when you explicitly specify EXTENT MANAGEMENT LOCAL. If you want to create a
temporary locally managed tablespace, use the CREATE TEMPORARY TABLESPACE
statement. 最后这段话是不是有点自相矛盾??
with 2K blocks, each extent would be equivalent to 64 database blocks). Each 128K
extent is represented by a bit in the extent bitmap for this file.
CREATE TABLESPACE lmtbsb DATAFILE '/u02/oracle/data/lmtbsb01.dbf' SIZE 50M
EXTENT MANAGEMENT LOCAL UNIFORM SIZE 128K;
You cannot specify the DEFAULT storage clause, MINIMUM EXTENT, or TEMPORARY
when you explicitly specify EXTENT MANAGEMENT LOCAL. If you want to create a
temporary locally managed tablespace, use the CREATE TEMPORARY TABLESPACE
statement. 最后这段话是不是有点自相矛盾??
1)create tablespace ..... temporary....
2)create temporary tablespace......
前者是向下兼容用来创建一个字典管理的临时表空间的,后者是用来创建一个本地管理的临时表空间的。
oracle不建议使用字典管理的表空间,如果想创建临时表空间,oracle建议用后者,不建议用前者。上面这段话的意思是说,如果你显式指定了EXTENT MANAGEMENT LOCAL,就表示要创建一个本地管理的
表空间,那么就不能像第一句那样加temporary(因为第一种用法只支持字典管理的表空间)。如果你想创建临时表空间,就用后一种方法创建。
Tablespaces allocate space in extents. Tablespaces can use two different methods to keep track of their free and used space: * Locally managed tablespaces: Extent management by the tablespace
* Dictionary managed tablespaces: Extent management by the data dictionaryWhen you create a tablespace, you choose one of these methods of space management. Later, you can change the management method with the DBMS_SPACE_ADMIN PL/SQL package.
The following example creates a tablespace with uniform 128K extents. (In a database
with 2K blocks, each extent would be equivalent to 64 database blocks). Each 128K
extent is represented by a bit in the extent bitmap for this file.
CREATE TABLESPACE lmtbsb DATAFILE '/u02/oracle/data/lmtbsb01.dbf' SIZE 50M
EXTENT MANAGEMENT LOCAL UNIFORM SIZE 128K;
You cannot specify the DEFAULT storage clause, MINIMUM EXTENT, or TEMPORARY
when you explicitly specify EXTENT MANAGEMENT LOCAL. If you want to create a
temporary locally managed tablespace, use the CREATE TEMPORARY TABLESPACE
statement.最后这段话是不是有点自相矛盾??
[/Quote
楼主觉得哪里矛盾了呢?