[oracle@localhost ~]$ sqlplus /nolog
SQL*Plus: Release 10.2.0.1.0 - Production on Sat May 17 04:16:44 2008
Copyright (c) 1982, 2005, Oracle. All rights reserved.
SQL> connect / as sysdba
Connected.
SQL> create tablespace test
2 datafile '/u01/app/oracle/oradata/orcl/test01.dbf'
3 size 100M
4 autoextend on next 50M maxsize unlimited
5 extent management local;
Tablespace created.
SQL> quit
Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
With the Partitioning, OLAP and Data Mining options
[oracle@localhost ~]$ sqlplus /nolog
SQL*Plus: Release 10.2.0.1.0 - Production on Sat May 17 04:21:28 2008
Copyright (c) 1982, 2005, Oracle. All rights reserved.
SQL> connect / as sysdba
Connected.
SQL> select tablespace_name,extent_management,allocation_type from dba_tablespaces where tablespace_name='TEST';
TABLESPACE_NAME EXTENT_MAN ALLOCATIO
------------------------------ ---------- ---------
TEST LOCAL SYSTEM
SQL> quit
Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
With the Partitioning, OLAP and Data Mining options
[oracle@localhost ~]$ sqlplus /nolog
SQL*Plus: Release 10.2.0.1.0 - Production on Sat May 17 05:10:25 2008
Copyright (c) 1982, 2005, Oracle. All rights reserved.
SQL> connect / as sysdba
Connected.
SQL> select initial_extent/1024 from dba_tablespaces where tablespace_name='TEST';
INITIAL_EXTENT/1024
-------------------
64
SQL> quit
Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
With the Partitioning, OLAP and Data Mining options
[oracle@localhost ~]$ sqlplus /nolog
SQL*Plus: Release 10.2.0.1.0 - Production on Sat May 17 05:14:55 2008
Copyright (c) 1982, 2005, Oracle. All rights reserved.
SQL> connect / as sysdba
Connected.
SQL> create table table1(x number)
2 tablespace test
3 storage(initial 70K next 70K);
Table created.
SQL> quit
Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
With the Partitioning, OLAP and Data Mining options
[oracle@localhost ~]$ sqlplus /nolog
SQL*Plus: Release 10.2.0.1.0 - Production on Sat May 17 05:23:51 2008
Copyright (c) 1982, 2005, Oracle. All rights reserved.
SQL> connect / as sysdba
Connected.
SQL> select extent_id,bytes/1024 from dba_extents where segment_name='TABLE1' and segment_type='TABLE';
EXTENT_ID BYTES/1024
---------- ----------
0 64
1 64
SQL> quit
Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
With the Partitioning, OLAP and Data Mining options
[oracle@localhost ~]$ sqlplus /nolog
SQL*Plus: Release 10.2.0.1.0 - Production on Sat May 17 06:02:43 2008
Copyright (c) 1982, 2005, Oracle. All rights reserved.
SQL> connect / as sysdba
Connected.
SQL> create table table2(x number)
2 tablespace test
3 storage(initial 130M next 130M);
Table created.
SQL> quit
Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
With the Partitioning, OLAP and Data Mining options
[oracle@localhost ~]$ sqlplus /nolog
SQL*Plus: Release 10.2.0.1.0 - Production on Sat May 17 06:10:38 2008
Copyright (c) 1982, 2005, Oracle. All rights reserved.
SQL> connect / as sysdba
Connected.
SQL> select extent_id,bytes/1024/1024 from dba_extents where segment_name='TABLE2' and segment_type='TABLE';
EXTENT_ID BYTES/1024/1024
---------- ---------------
0 8
1 8
2 8
3 8
4 8
5 8
6 8
7 8
8 8
9 8
10 8
EXTENT_ID BYTES/1024/1024
---------- ---------------
11 8
12 8
13 8
14 8
15 8
16 8
17 rows selected.
SQL> quit
Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
With the Partitioning, OLAP and Data Mining options
来自 “ ITPUB博客 ” ,链接:https://blog.itpub.net/9542082/viewspace-274667/ ,如需转载,请注明出处,否则将追究法律责任。