ORA-01652 unable to extend temp segment by 8192 in tablespace
ORA-01652 unable to extend temp segment by 8192 in tablespace DUONG_TBS
Nguyên nhân:
Lỗi ORA-01652: unable to extend temp segment by 8192 in tablespace DUONG_TBS =>> do thiếu dung lượng tablespace (tablespace bị đầy FULL), có thể là temp hoặc là tablespace chứa table đang thực hiện thao tác dữ liệu.
Khắc phục:
Add thêm datafile vào trong tablespace chứa bảng và add tempfile cho temp tablespace
ALTER TABLESPACE DUONG_TBS ADD DATAFILE SIZE 500M AUTOEXTEND ON NEXT 100M MAXSIZE UNLIMITED; ALTER TABLESPACE TEMP ADD TEMPFILE SIZE 500M AUTOEXTEND ON NEXT 100M MAXSIZE UNLIMITED;
Xem thêm:
- Q37 Which three statements are true about advanced connection options supported by Oracle Net for connection to Oracle Database instances?
- Data Enrichment là gì?
- Quản trị Controlfile trong Oracle database RAC 19c
- Q91. Which three are true about creating container databases (CDBs) and pluggable databases (PDBs) in Oracle 19c and later releases?
- Sử dụng Database Link trong Oracle Database
Bài viết cùng chủ đề:
-
RMAN-06059: expected archived log not found, loss of archived log compromises recoverability
-
ORA-00845 MEMORY_TARGET not supported on this system
-
ORA-03113 end-of-file on communication channel
-
Error The OpenJDK JVM is not supported on this platform when install Oracle Goldengate Studio
-
ORA-12754 Feature PDB SNAPSHOT CAROUSEL is disabled due to missing capability
-
ORA-01950 no privileges on tablespace ‘USERS’
-
ORA-38708 not enough space for first flashback database log file
-
ORA-19804 cannot reclaim 1264643584 bytes disk space from 8657043456 bytes limit
-
ORA-00821: Specified value of sga_target 1504M is too small
-
Lỗi ORA-16397: statement redirection from Oracle Active Data Guard standby database to primary database failed
-
Lỗi ORA-16470 Oracle Data Guard Oracle 19c
-
Khắc phục lỗi MoTTY X11 proxy: Unsupported authorisation protocol
