|
-
10g - Locally managed TS + ASSM
bore,Are you sure ASSM is default in oracle 10g!!!
C:\>sqlplus/nolog
SQL*Plus: Release 10.1.0.2.0 - Production on Mon Aug 13 22:33:55 2007
Copyright (c) 1982, 2004, Oracle. All rights reserved.
SQL> conn sys as sysdba
Enter password:
Connected.
SQL> create tablespace test
2 datafile 'e:\test.dbf' size 10m;
Tablespace created.
SQL> select tablespace_name,extent_management,segment_space_management
2 from dba_tablespaces;
TABLESPACE_NAME EXTENT_MAN SEGMEN
------------------------------ ---------- ------
SYSTEM LOCAL MANUAL
UNDOTBS1 LOCAL MANUAL
SYSAUX LOCAL AUTO
TEMP LOCAL MANUAL
USERS LOCAL AUTO
EXAMPLE LOCAL AUTO
TEST LOCAL MANUAL
11 rows selected.
the default behavior of oracle 10g is MANUAL, for segment space management.
Last edited by liakat; 08-13-2007 at 12:49 PM.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|