Oracle-L: RE: Tablespace management.

From: Mark Leith <mark_at_cool-tools.co.uk>
Date: Mon, 02 Jun 2003 06:50:18 -0800
Message-ID: <F001.005A8139.20030602065018@fatcity.com>

SQL> select * from v$version;

BANNER

Oracle9i Enterprise Edition Release 9.2.0.1.0 - Production PL/SQL Release 9.2.0.1.0 - Production
CORE 9.2.0.1.0 Production
TNS for 32-bit Windows: Version 9.2.0.1.0 - Production NLSRTL Version 9.2.0.1.0 - Production

SQL> CREATE TABLESPACE LOCAL_UNIFORM_AUTO   2 DATAFILE
  3 'C:\Oracle\oradata\ORCL\ULMTA01.DBF' SIZE 10 M   4 LOGGING
  5 ONLINE
  6 PERMANENT
  7 EXTENT MANAGEMENT LOCAL
  8 SEGMENT SPACE MANAGEMENT AUTO; Tablespace created.

SQL> select extent_management, allocation_type, segment_space_management 2 from dba_tablespaces
3 where tablespace_name = 'LOCAL_UNIFORM_AUTO';

EXTENT_MAN ALLOCATIO SEGMEN
---------- --------- ------
LOCAL SYSTEM AUTO SQL> create table ULMTA_TEST (col1 number, col2 clob, col3 blob) 2 tablespace local_uniform_auto;

Table created.

SQL> select table_name, tablespace_name
2 from dba_tables
3 where table_name = 'ULMTA_TEST';

TABLE_NAME                     TABLESPACE_NAME
------------------------------ ------------------------------
ULMTA_TEST                     LOCAL_UNIFORM_AUTO

Seems to work fine ;)

Regards

Mark

 Mark Leith             | T: +44 (0)1905 330 281
 Sales & Marketing      | F: +44 (0)870 127 5283
 Cool Tools UK Ltd      | E: mark_at_cool-tools.co.uk
===================================================
           http://www.cool-tools.co.uk
       Maximising throughput & performance

-----Original Message-----
Sent: 02 June 2003 15:05
To: Multiple recipients of list ORACLE-L

Bulbul,

That is not correct. At least in 9.2.0.3? I am not sure what it would be in 9.2.0.1, but I doubt it would be different.

SQL> select extent_management, allocation_type, segment_space_management 2 from dba_tablespaces
3 where tablespace_name = 'SCL_AW_Y03Q2_DATA' 4 /

EXTENT_MAN ALLOCATIO SEGMEN
---------- --------- ------
LOCAL UNIFORM AUTO SQL>
SQL> select * from v$version;

BANNER

Oracle9i Enterprise Edition Release 9.2.0.3.0 - Production PL/SQL Release 9.2.0.3.0 - Production
CORE 9.2.0.3.0 Production
TNS for Compaq Tru64 UNIX: Version 9.2.0.3.0 - Production NLSRTL Version 9.2.0.3.0 - Production

SQL> create table testl (col1 number, col2 clob, col3 blob) 2 tablespace scl_aw_y03q2_data
3 /

Table created.

Could you please let us know where you got that information.

Arup Nanda

---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.484 / Virus Database: 282 - Release Date: 27/05/2003



-- 

Please see the official ORACLE-L FAQ: http://www.orafaq.net


-- 

Author: Mark Leith
  INET: mark_at_cool-tools.co.uk

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Received on Mon Jun 02 2003 - 09:50:18 CDT