ORA-01652 unable to extend temp segment by 8192 in tablespace

Posted on 12/06/202406/03/2025 by Tran Anh

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 bị đầy FULL), có thể là temp hoặc là tablespace chứa table đang thực hiện thao tác dữ liệu.

Khắc phục:

Add thêm datafile vào trong tablespace chứa bảng và 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:

Q80 Which three instance situations are possible with the Oracle Database server without multitenant?
Test hiệu năng hệ thống Postgresql với pgbench
Laragon là gì? Cài đặt Laragon như thế nào?
Tạo lại controlfile khi bị mất hỏng
Q141. Which three actions are performed by Database Upgrade Assistant (DBUA)?

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 phục lỗi MoTTY X11 proxy: Unsupported authorisation protocol

0 0 đánh giá

Đánh giá bài viết

Theo dõi

0 Góp ý

Phản hồi nội tuyến

Xem tất cả bình luận

ORA-01652 unable to extend temp segment by 8192 in tablespace

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 phục lỗi MoTTY X11 proxy: Unsupported authorisation protocol

Phần mềm bản quyền

Update sản phẩm

Thêm mới sản phẩm

Đặt hàng, thanh toán

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 phục lỗi MoTTY X11 proxy: Unsupported authorisation protocol

Đăng nhập

Đăng ký