Shulou(Shulou.com)05/31 Report--

This article is to share with you about the expansion of ORACLE tablespace operation is how, the editor feels very practical, so share with you to learn, I hope you can learn something after reading this article, say no more, follow the editor to have a look.

1. Problem: error reporting when importing data into the page: ora-01688

2. The cause of the problem:

(1) ORA-01688: cannot be extended through 1024 tablespaces. This error indicates that the tablespaces have been used up and that new spaces cannot be allocated. This is because the tablespace is extended in manual mode rather than automatic mode

3. Solution:

(1). Determine which tablespace is full (check the tablespace utilization):

SELECT c.ts#, c.name, d.contents, d.extent_management, e.file_bytes, c.used

SUBSTR (c.used / e.file_bytes * 100,1,5)

FROM (SELECT name, ts#, SUM (used) used

FROM (SELECT a.allocated_space * (SELECT value-- query the current value of db_block_size)

FROM v$parameter

WHERE name = 'db_block_size') / 1024 / 1024 used

B.ts#, b.name

FROM v$filespace_usage a, v$tablespace b

WHERE a.tablespace_id = b.ts#)

GROUP BY name, ts#) c

Dba_tablespaces d

(SELECT ts#, SUM (bytes) / 1024 / 1024 file_bytes

FROM v$datafile

GROUP BY ts#) e

WHERE c.name = d.tablespace_name

AND e.ts# = c.ts#

ORDER BY ts#

Results:

(2) to expand the tablespace: TS_APP_DATA_03, first determine the tablespace file:

SELECT FILE#, NAME FROM V$DATAFILE

Results:

(3) Update data tablespace file size:

ALTER DATABASE DATAFILE 9 RESIZE 4G

Note:'9' here is the space found above with FILE# = 9; 4G is the reallocated space size.

(4) Update result:

The above is what the operation of expanding ORACLE tablespaces is like. The editor believes that there are some knowledge points that we may see or use in our daily work. I hope you can learn more from this article. For more details, please follow the industry information channel.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.