Recently, I have encountered such a problem: the previous time web page query Oracle table is normal, but it has not been displayed recently. Printing SQL Pl / SQL Devoloper Execution, "Unable to extend the TEMP segment through 8 (in Table Space XXX), there is a page, you can query the record, but you can't count data! After analyzing, it is possible to: Oracle Temporary Table Space, because Oracle always assigns continuous space, one but not enough can allocate space or allocation does not continuously appear.
Workaround: I know that because Oracle will use the table space as the logical structure - unit, the physical structure of the table space is data file, the data file is physically created on the disk, and all objects of the table space exist on the disk, and adds to the table space. Space, you must add data files. First look at the free space of the specified table space, use the view sys.dba_free_space, each record in the view represents the fragmentation of the available space:
SQL> SELECT FILE_ID, BLOCK_ID, Blocks, Bytes from sys.dba_free_space where tablespace_name = 'xxx';
The returned information can initially determine the maximum block of the available space, see if it is less than the size mentioned in the error message, then check the default tablespace parameters:
SQL> SELECT INITIAL_EXTENT, Next_EXTENT, Min_EXTENTS, PCT_INCREASE from sys.dba_tablespaces where tablespace_name = 'xxx';
Modify the default storage value of the episode table space by the following SQL command:
SQL> ALTER TABLESPACE NAME DEFAULT Storage (Initial 64K Next 64K);
Appropriately increase the size of the default value is possible to solve the error problem, or you can solve this problem by modifying the user's temporary table space size:
SQL> ALTER USER Username Temporary TableSpace New_Tablespace_name;
Using the alter tablespace command, one but complete, the added space can be used, there is no need to exit the database or make the table space offline, but to note that once the data file is added, it can no longer delete it. To delete it, it is necessary to delete Table space. Don't like friends with commands, you can also find the tablespace of the problem library through the Oracle tool DBA Studio. The specific location is "Storage" -> "Table Space" -> "XXX", the right block "General Information", you can see , Data file usage, select storage, appropriate modification, "first make size", and "next size", the problem may be resolved, then select "XXX" point mouse button, select "Add Data File", appropriate modification "The" Increment "size of" File Size "and" Storage "of" General Information "and" Data Files have been automatically expanded ", and the problem can also be solved!
