Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

export and import

853441Apr 9 2011 — edited Apr 11 2011

i took export from oracle 8.1.7/ windows 2000

usiing

exp uname/pasword file=exp_04.dmp full=y compress=n

and imported into
oracle 8.1.7 / REDHAT LINUX 4

i have posted the errors from import log

IMP-00017: following statement failed with ORACLE error 1658:
"CREATE INDEX "PRMAITCUM_IND3" ON "PRMAITCUM" ("PAYCALPERIOD" , "EARNINGDEDU"
"CTION" , "EMPNO" ) PCTFREE 10 INITRANS 2 MAXTRANS 255 STORAGE(INITIAL 1993"
"60512 NEXT 99483648 MINEXTENTS 1 MAXEXTENTS 2147483645 PCTINCREASE 50 FREEL"
"ISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT) TABLESPACE "INDX" LOGGING"
IMP-00003: ORACLE error 1658 encountered
ORA-01658: unable to create INITIAL extent for segment in tablespace INDX
IMP-00017: following statement failed with ORACLE error 1658:
"CREATE UNIQUE INDEX "UNQ_PRMAITCUM" ON "PRMAITCUM" ("EMPNO" , "EARNINGDEDUC"
"TION" , "PAYPERIOD" , "PAYCALPERIOD" , "SUPPLEMENTARY" , "AMT" ) PCTFREE 1"
"0 INITRANS 2 MAXTRANS 255 STORAGE(INITIAL 298844160 NEXT 149159936 MINEXTEN"
"TS 1 MAXEXTENTS 2147483645 PCTINCREASE 50 FREELISTS 1 FREELIST GROUPS 1 BUF"
"FER_POOL DEFAULT) TABLESPACE "INDX" LOGGING"
IMP-00003: ORACLE error 1658 encountered
ORA-01658: unable to create INITIAL extent for segment in tablespace INDX

alert log error

ORA-1652: unable to extend temp segment by 36480 in tablespace INDX
Fri Apr 8 21:33:27 2011
ORA-1652: unable to extend temp segment by 16 in tablespace INDX
ORA-1652: unable to extend temp segment by 16 in tablespace INDX
ORA-1652: unable to extend temp segment by 144 in tablespace INDX
ORA-1652: unable to extend temp segment by 144 in tablespace INDX
ORA-1652: unable to extend temp segment by 144 in tablespace INDX
ORA-1652: unable to extend temp segment by 144 in tablespace INDX
ORA-1652: unable to extend temp segment by 144 in tablespace INDX
ORA-1652: unable to extend temp segment by 144 in tablespace INDX
ORA-1652: unable to extend temp segment by 16 in tablespace INDX
ORA-1652: unable to extend temp segment by 16 in tablespace INDX
ORA-1652: unable to extend temp segment by 16 in tablespace INDX
ORA-1652: unable to extend temp segment by 16 in tablespace INDX
ORA-1652: unable to extend temp segment by 16 in tablespace INDX
ORA-1652: unable to extend temp segment by 16 in tablespace INDX

after import

many user tables are in STSTEM tablespace

then i altered those tables to user tablespace

then i rebuild the respective indexes of those tables to indx tablespace

the error was
ORA-1652: unable to extend temp segment

then i rebuild the respective indexes of those tables to user tablespace.

when logging into client terminal

and tried to insert into the table

i get following errors

ora-04031
ora-06508
ora-04088

anyone please help me.

i have little exposure in oracle 8i

santhanam

when i try to inser data in any

Locked Post

New comments cannot be posted to this locked post.

Locked on May 9 2011

Added on Apr 9 2011

#general-database-discussions

5 comments

469 views