Re: Commit in batch

From: Karl R. <kreitsch_at_zdnetonebox.com>
Date: 2000/05/29
Message-ID: <19a85048.7b9f4f72@usw-ex0104-031.remarq.com>#1/1

Hello Robert,
than you for your tip, but i did i understand wrong thw issue with maxtextents on tempoorary Tablespaces?

Oracle 7.3.4.5, AIX
In this environment the Tablespace ihas maxtextents set and is temporary.

SQL> select * from dba_tablespaces where tablespace_name = 'TS_TEMP';

TABLESPACE_NAME                INITIAL_EXTENT NEXT_EXTENT

MIN_EXTENTS MAX_EXTENTS PCT_INCREASE

------------------------------ -------------- ----------- -------

---- ----------- ------------
STATUS CONTENTS
--------- ---------

TS_TEMP                              20971520
20971520           1         999            0

ONLINE TEMPORARY SQL> SQL> create table xx ( yy NUMBER ) Tablespace ts_temp; create table xx ( yy NUMBER ) Tablespace ts_temp
*

ERROR at line 1:
ORA-02195: Attempt to create PERMANENT object in a TEMPORARY tablespace

Karl Reitschuster
Senior Consultant CSC Ploenzke AG
Oracle Databases, Implementation, Performance-Tuning <!Jesus is Lord!>
* Sent from RemarQ http://www.remarq.com The Internet's Discussion Network *
The fastest and easiest way to search and participate in Usenet - Free! Received on Mon May 29 2000 - 00:00:00 CDT