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:
- Q91 Which two statements are true about UNDO and REDO?
- Tìm hiểu hệ quản trị CSDL IBM Db2
- Q41. Which two are true about Optimizer Statistics?
- Cài đặt và cấu hình Grafana trên linux 8 – step by step install Grafana on Linux 8
- Q140. Which two are true about unplugging an application container from a container database and plugging it into a different container 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
