Total Pageviews

Sunday, August 28, 2022

ORA-01658: unable to create INITIAL extent for segment in tablespace SYSTEM

Import terminated successfully with warnings.

ALTER DATABASE DATAFILE 'C:\ORACLEXE\APP\ORACLE\ORADATA\XE\SYSTEM.DBF' RESIZE 3000M;

Or by adding a second datafile to the tablespace:

ALTER TABLESPACE SYSTEM

ADD DATAFILE 'C:\ORACLEXE\APP\ORACLE\ORADATA\XE\SYSTEM.DBF'

SIZE 1000M;

Or just allow the datafile to auto extend:

ALTER DATABASE

DATAFILE 'C:\ORACLEXE\APP\ORACLE\ORADATA\XE\SYSTEM.DBF'

AUTOEXTEND ON

MAXSIZE UNLIMITED;

No comments:

Post a Comment

The Fix for the Double Login Prompt when run report 6i from form

  Since you are running in a Desktop (client-server) architecture , the login prompt and buffering are directly tied to how the local Window...