the output is
SQL> select object_name from dba_objects where object_name like 'PCT%';
OBJECT_NAME
--------------------------------------------------------------------------------------------------------------------------------
PCT$
also the description
====================
SQL> desc pct$;
Name Null? Type
------------------------------------------------------------------------- -------- -------------------------------------------------
TABLESPACE_NAME VARCHAR2(30)
AVAIL NUMBER
USED NUMBER
FREE NUMBER
Us
ed % VARCHAR2(7)
CONTENTS VARCHAR2(9)
EXTENT_MANAGEMENT VARCHAR2(10)
STATUS VARCHAR2 (9)
why the temp file shows 0 as size?
Last edited by dbasan; 05-18-2004 at 02:11 PM.
"What is past is PROLOGUE"
Reply With Quote