Newbie temporary tablespaces question...
From: Dean Wittke <dwittke_at_harp.aix.calpoly.edu>
Date: Fri, 17 Jun 1994 22:35:40 GMT
Message-ID: <1994Jun17.223540.106547_at_zeus.aix.calpoly.edu>
Date: Fri, 17 Jun 1994 22:35:40 GMT
Message-ID: <1994Jun17.223540.106547_at_zeus.aix.calpoly.edu>
Greetings,
USERNAME USER_ID PA DEFAULT_TABLESPACE TEMPORARY_TABLESPACE ----------------------------- ---------- -------- --------------------------------------------------- SYS 0 x SYSTEM MISC_DATA SYSTEM 5 x TOOLS MISC_DATA SCOTT 8 x TOOLS TEMP AXIS 9 x AXIS1 AXIS1 BARBARA 13 x SYSTEM SYSTEM From sys.dba_tablespace TABLESPACE_NAME INITIAL_EX NEXT_EXTEN MIN_EXTENT MAX_EXTENT PCT_INCREA STATUS ------------------------------ ---------- ---------- ---------- ---------- ---------- --------- SYSTEM 12288 12288 1 249 0 ONLINE RBS 204800 204800 10 50 50 INVALID TEMP 262144 262144 1 249 0 ONLINE TOOLS 20480 20480 1 249 50 ONLINE USERS 20480 20480 1 249 50 ONLINE MISC_DATA 167772160 5242880 2 50 0 INVALID ADMIN 12288 12288 1 100 0 ONLINE AXIS1 53248 53248 2 50 0 ONLINE MISC_RBS 20971520 6291456 2 50 50 INVALID MISC_RBS2 20971520 6291456 2 50 50 ONLINEReceived on Sat Jun 18 1994 - 00:35:40 CEST