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 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:

Q106 In the spfile of a single instance database, LOCAL_LISTENER is set to LISTENER_1
Cách tạo và tối ưu thẻ meta trong WordPress
Q80. Which two are true about creating RMAN backups for an Oracle container database?
Q86. A container database (CDB) contains two pluggable databases PDB1 and PDB2
Q34 Which three statements are true about the Automatic Diagnostic Repository (ADR)?

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