Strange, create a table in that tablespace then try to query the view again.
Note: When you create or resize tempfiles, they are not always guaranteed allocation of disk space for the file size specified. On certain file systems, disk blocks are not allocated on file creation or resizing, but before the blocks are accessed. This enables fast tempfile creation or resizing.
Last edited by Calvin_Qiu; 11-10-2002 at 10:26 PM.
Oracle Certified Master - September, 2003, the Second OCM in China
*** LOOKING for PART TIME JOB***
Data Warehouse & Business Intelligence Expert
MCSE, CCNA, SCJP, SCSA from 1998
Reply With Quote