ukmca
asked on
how to solve ORA-01658 error ?
how 2 find the solution for this error , while creating a table ?
ORA-01658: unable to create INITIAL extent for segment in tablespace ABFXM
ukmca.
ORA-01658: unable to create INITIAL extent for segment in tablespace ABFXM
ukmca.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
I am getting the following ;
Connected to: Personal Oracle8i Release 8.1.7.0.0 - Production
With the Partitioning option
JServer Release 8.1.7.0.0 - Production
Export file created by EXPORT:V08.01.06 via conventional path
Warning: the objects were exported by CORE4012, not by you
import done in WE8ISO8859P1 character set and WE8ISO8859P1 NCHAR character set
export server uses US7ASCII NCHAR character set (possible ncharset conversion)
. importing CORE4012's objects into REPOS_MANAGER
IMP-00017: following statement failed with ORACLE error 1658:
"CREATE TABLE "CK_INSTALLED_OBJECTS" ("CI_STAGE" VARCHAR2(20) NOT NULL ENABL"
"E, "CI_TYPE" VARCHAR2(13) NOT NULL ENABLE, "CI_NAME" VARCHAR2(128) NOT NULL"
" ENABLE, "CI_CREATED" VARCHAR2(1) NOT NULL ENABLE, "CI_NO_OF_ROWS" NUMBER, "
""CI_DIR" VARCHAR2(10), "CI_FILENAME" VARCHAR2(12), "CI_COMMENT" VARCHAR2(10"
"0), "CI_PIN_FLAG" VARCHAR2(1), "CI_OWNER" VARCHAR2(40), "CI_INITIAL" VARCHA"
"R2(6), "CI_NEXT" VARCHAR2(6), "CI_PCTINCREASE" VARCHAR2(2), "CI_TABLESPACE""
" VARCHAR2(20), "CI_TABLE_IRID" NUMBER) PCTFREE 10 PCTUSED 40 INITRANS 1 MA"
"XTRANS 255 LOGGING STORAGE(INITIAL 1048576 NEXT 16384 MINEXTENTS 1 MAXEXTEN"
"TS 2147483645 PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAU"
"LT) "
IMP-00003: ORACLE error 1658 encountered
ORA-01658: unable to create INITIAL extent for segment in tablespace TBS_RGTAB
. . importing table "CK_PRODUCT_ELEMENTS" 545 rows imported
Import terminated successfully with warnings.
any help?
Connected to: Personal Oracle8i Release 8.1.7.0.0 - Production
With the Partitioning option
JServer Release 8.1.7.0.0 - Production
Export file created by EXPORT:V08.01.06 via conventional path
Warning: the objects were exported by CORE4012, not by you
import done in WE8ISO8859P1 character set and WE8ISO8859P1 NCHAR character set
export server uses US7ASCII NCHAR character set (possible ncharset conversion)
. importing CORE4012's objects into REPOS_MANAGER
IMP-00017: following statement failed with ORACLE error 1658:
"CREATE TABLE "CK_INSTALLED_OBJECTS" ("CI_STAGE" VARCHAR2(20) NOT NULL ENABL"
"E, "CI_TYPE" VARCHAR2(13) NOT NULL ENABLE, "CI_NAME" VARCHAR2(128) NOT NULL"
" ENABLE, "CI_CREATED" VARCHAR2(1) NOT NULL ENABLE, "CI_NO_OF_ROWS" NUMBER, "
""CI_DIR" VARCHAR2(10), "CI_FILENAME" VARCHAR2(12), "CI_COMMENT" VARCHAR2(10"
"0), "CI_PIN_FLAG" VARCHAR2(1), "CI_OWNER" VARCHAR2(40), "CI_INITIAL" VARCHA"
"R2(6), "CI_NEXT" VARCHAR2(6), "CI_PCTINCREASE" VARCHAR2(2), "CI_TABLESPACE""
" VARCHAR2(20), "CI_TABLE_IRID" NUMBER) PCTFREE 10 PCTUSED 40 INITRANS 1 MA"
"XTRANS 255 LOGGING STORAGE(INITIAL 1048576 NEXT 16384 MINEXTENTS 1 MAXEXTEN"
"TS 2147483645 PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAU"
"LT) "
IMP-00003: ORACLE error 1658 encountered
ORA-01658: unable to create INITIAL extent for segment in tablespace TBS_RGTAB
. . importing table "CK_PRODUCT_ELEMENTS" 545 rows imported
Import terminated successfully with warnings.
any help?
To give an indication of your fragmentation you can run::
Set LINESIZE 132
Set PAGESIZE 100
Column KBytesFree Format 999,999,990.00
Column KBytesLargest Format 999,999,990.00
Column KBytesSmallest Format 999,999,990.00
Column NoOfSegments Format 999,999,990
Select TABLESPACE_NAME
,Sum(Bytes)/1024 KBytesFree
,Max(Bytes)/1024 KBytesLargest
,Min(Bytes)/1024 KBytesSmallest
,Count(*) NoOfSegments
From DBA_FREE_SPACE
Group By TABLESPACE_NAME
In the long term you should address fragmentation issues by re-assessing your storage and defragmenting the tablespace(s).
Regards
Chedgey