Home » RDBMS Server » Backup & Recovery » exp/imp(refresh)
exp/imp(refresh) [message #205811] Mon, 27 November 2006 14:04 Go to next message
nisha22
Messages: 6
Registered: September 2005
Junior Member
Hi All,
I have created db on target m/c with apporpriate tablespaces and sizes as that of source but my import has many errors in thge log,the import command is


/util1at/app/oracle/product/8.1.7.3_64/bin/imp system/passwd FILE=/backup1t/hr8cnv/exp/hr8cnv.dmp IGNORE=Y ANALYZE=N FULL=Y LOG=/user1/oracle2t/log/import_hr
8cnv.log &

Can somebody help me out where iam going wrong with it.


Below is export and import log ,

%%%%% Start full export of 'hr8prd': Wed Nov 15 22:30:02 EST 2006 %%%%%

Export: Release 8.1.7.3.0 - Production on Wed Nov 15 22:30:02 2006

(c) Copyright 2000 Oracle Corporation. All rights reserved.


Connected to: Oracle8i Enterprise Edition Release 8.1.7.3.0 - 64bit Production
With the Partitioning option
JServer Release 8.1.7.3.0 - 64bit Production
Export done in WE8ISO8859P1 character set and WE8ISO8859P1 NCHAR character set

About to export the entire database ...
. exporting tablespace definitions
. exporting profiles
. exporting user definitions
. exporting roles
. exporting resource costs
. exporting rollback segment definitions
. exporting database links
. exporting sequence numbers
. exporting directory aliases
. exporting context namespaces
. exporting foreign function library names
. exporting object type definitions
. exporting system procedural objects and actions
. exporting pre-schema procedural objects and actions
. exporting cluster definitions
. about to export SYSTEM's tables via Direct Path ...
. . exporting table ALERTLOG_TEMP 0 rows exported
EXP-00067: Table DEF$_AQCALL will be exported in conventional path.
. . exporting table DEF$_AQCALL 0 rows exported
EXP-00067: Table DEF$_AQERROR will be exported in conventional path.
. . exporting table DEF$_AQERROR 0 rows exported
. . exporting table DEF$_CALL 0 rows exported
. . exporting table DEF$_CALLDEST 0 rows exported
. . exporting table DEF$_DEFAULTDEST 0 rows exported
. . exporting table DEF$_DESTINATION 0 rows exported
. . exporting table DEF$_ERROR 0 rows exported
EXP-00067: Table DEF$_LOB will be exported in conventional path.
. . exporting table DEF$_LOB 0 rows exported
. . exporting table DEF$_ORIGIN 0 rows exported
. . exporting table DEF$_PROPAGATOR 0 rows exported
. . exporting table DEF$_PUSHED_TRANSACTIONS 0 rows exported
EXP-00067: Table DEF$_TEMP$LOB will be exported in conventional path.
. . exporting table DEF$_TEMP$LOB 0 rows exported
. . exporting table EVT_CARRIER_CONFIGURATION 0 rows exported
. . exporting table EVT_DEST_PROFILE 0 rows exported

. exporting views
. exporting stored procedures
. exporting operators
. exporting indextypes
. exporting bitmap, functional and extensible indexes
. exporting posttables actions
. exporting triggers
. exporting snapshots
. exporting snapshot logs
. exporting job queues
. exporting refresh groups and children
. exporting dimensions
. exporting post-schema procedural objects and actions
. exporting user history table
. exporting default and system auditing options
. exporting statistics
Export terminated successfully with warnings.

import log
-----------------------
***********************

Connected to: Oracle8i Enterprise Edition Release 8.1.7.3.0 - 64bit Production
With the Partitioning option
JServer Release 8.1.7.3.0 - 64bit Production

Export file created by EXPORT:V08.01.07 via direct path

Warning: the objects were exported by OPS$ORACLE2P, not by you

import done in WE8ISO8859P1 character set and WE8ISO8859P1 NCHAR character set
IMP-00032: SQL statement exceeded buffer length
IMP-00032: SQL statement exceeded buffer length
IMP-00032: SQL statement exceeded buffer length
IMP-00032: SQL statement exceeded buffer length
IMP-00008: unrecognized statement in the export file:
ULT TABLESPACE "PSTEMP" TEMPORARY TABLESPACE "PSTEMP"
IMP-00008: unrecognized statement in the export file:
GRA"WILLIARS"
IMP-00017: following statement failed with ORACLE error 933:
"GRANT "PSUSER" TO "AZ2282" TO "AZ23681""
IMP-00003: ORACLE error 933 encountered
ORA-00933: SQL command not properly ended
IMP-00017: following statement failed with ORACLE error 1917:
"GRANT "PSUSER" TO "AZ66519""
IMP-00003: ORACLE error 1917 encountered
ORA-01917: user or role 'AZ66519' does not exist
IMP-00017: following statement failed with ORACLE error 1917:
"GRANT "PSUSER" TO "AZ66446""
IMP-00003: ORACLE error 1917 encountered
ORA-01652: unable to extend temp segment by 64 in tablespace TEMP
IMP-00017: following statement failed with ORACLE error 1652:
"CREATE INDEX "QUEST_IX_RUN_OBS_TAB_ITM_NDX1" ON "QUEST_IX_RUN_OBS_TABLE_ITE"
"M" ("RUN_ID" , "OBSERVATION_ID" , "COLUMN_NO" ) PCTFREE 10 INITRANS 2 MAXT"
"RANS 255 STORAGE(INITIAL 94371840 NEXT 2097152 MINEXTENTS 1 MAXEXTENTS 2147"
"483645 PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT) TAB"
"LESPACE "TOOLS" LOGGING"
IMP-00003: ORACLE error 1652 encountered
ORA-01652: unable to extend temp segment by 64 in tablespace TEMP
IMP-00017: following statement failed with ORACLE error 1652:
"ALTER TABLE "QUEST_IX_RUN_OBS_TABLE_ITEM" ADD CONSTRAINT "QUEST_IX_RUN_OBS"
"_TABLE_ITEM_PK" PRIMARY KEY ("RUN_ID", "OBSERVATION_ID", "ROW_NO", "COLUMN_"
"NO", "SEQUENCE_NO") USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255 STORAGE("
IMP-00017: following statement failed with ORACLE error 1652:
"ALTER TABLE "QUEST_IX_RUN_OBS_TABLE_ITEM" ADD CONSTRAINT "QUEST_IX_RUN_OBS"
"_TABLE_ITEM_PK" PRIMARY KEY ("RUN_ID", "OBSERVATION_ID", "ROW_NO", "COLUMN_"
"NO", "SEQUENCE_NO") USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255 STORAGE("
"INITIAL 96665600 NEXT 720896 MINEXTENTS 1 MAXEXTENTS 2147483645 PCTINCREASE"
" 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT) TABLESPACE "TOOLS" EN"
"ABLE "
IMP-00003: ORACLE error 1652 encountered
ORA-01652: unable to extend temp segment by 64 in tablespace TEMP
. . importing table "QUEST_IX_RUN_PARAMETERS"
IMP-00020: long column too large for column buffer size (512)
IMP-00028: partial import of previous table rolled back: 27 rows rolled back
IMP-00008: unrecognized statement in the export file:

IMP-00008: unrecognized statement in the export file:

IMP-00008: unrecognized statement in the export file:
Claim Entry^A
IMP-00008: unrecognized statement in the export file:
Enrollment^A
IMP-00008: unrecognized statement in the export file:
Enrollment^A
IMP-00008: unrecognized statement in the export file:

IMP-00017: following statement failed with ORACLE error 942:
"CREATE UNIQUE INDEX "PS_MTCH_GFT_CTL_ZN" ON "PS_MTCH_GFT_CTL_ZN" ("EFFDT" D"
"ESC ) PCTFREE 10 INITRANS 2 MAXTRANS 255 STORAGE(INITIAL 16384 NEXT 106496"
" MINEXTENTS 1 MAXEXTENTS 110 PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BU"
"FFER_POOL DEFAULT) TABLESPACE "PSINDEX" LOGGING"
IMP-00003: ORACLE error 942 encountered
ORA-00942: table or view does not exist
IMP-00017: following statement failed with ORACLE error 942:
"CREATE UNIQUE INDEX "PS_NDT_HCE_TBL" ON "PS_NDT_HCE_TBL" ("EFFDT" DESC ) P"
"CTFREE 10 INITRANS 2 MAXTRANS 255 STORAGE(INITIAL 16384 NEXT 8192 MINEXTENT"
"S 1 MAXEXTENTS 110 PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL "
"DEFAULT) TABLESPACE "PSINDEX" LOGGING"
IMP-00003: ORACLE error 942 encountered
ORA-00942: table or view does not exist
IMP-00017: following statement failed with ORACLE error 942:
"CREATE UNIQUE INDEX "PS_OBSTACLES_MOBIL" ON "PS_OBSTACLES_MOBIL" ("EMPLID" "
", "EFFDT" DESC , "OBSTACLES_MOBILITY" ) PCTFREE 10 INITRANS 2 MAXTRANS 255"
" STORAGE(INITIAL 16384 NEXT 8192 MINEXTENTS 1 MAXEXTENTS 110 PCTINCREASE 0 "
"FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT) TABLESPACE "PSINDEX" LOG"
"GING"
IMP-00041: Warning: object created with compilation warnings
"CREATE FORCE VIEW "SYSADM"."PS_TL_COMP_BAL_SCH" (""
"ROWSECCLASS","EMPLID","EMPL_RCD","NAME") AS "
"SELECT V.ROWSECCLASS ,V.EMPLID ,V.EMPL_RCD , V.NAME FROM"
" PS_TL_ADM_EERCD_VW V WHERE EXISTS ( SELECT 'X' FROM PS_TL_EMPL_COMP E"
" WHERE E.EMPLID=V.EMPLID AND V.EMPL_RCD=E.EMPL_RCD)"
IMP-00041: Warning: object created with compilation warnings
"CREATE FORCE VIEW "SYSADM"."PS_TL_ATTEND_HSRCH" (""
"ROWSECCLASS","EMPLID","DUR","EXCEPTION_ID","PUNCH_BEGIN","NAME") AS "
"SELECT A.ROWSECCLASS , B.EMPLID , B.DUR ,"
" B.EXCEPTION_ID , B.PUNCH_BEGIN , C.NAME FROM PS_TL_ADM_SRCH_VW A ,"
" PS_TL_ATTEND_HIST B , PS_PERSONAL_DATA C WHERE A.EMPLID = B.EMPLID"
" AND A.EMPLID = C.EMPLID"

"import_hr8cnv.log" 102687 lines, 6151457 characters
Re: exp/imp(refresh) [message #205813 is a reply to message #205811] Mon, 27 November 2006 14:26 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10672
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
Are the target and source databases on different OS and Oralce versions?
Was the DMP file ftp'ied across the machine? ( Make sure you used BIN mode).
Make sure you make an export with compress=N
Your temp tablespace is not sufficient in target. Make it larger.
Re: exp/imp(refresh) [message #206104 is a reply to message #205813] Tue, 28 November 2006 15:02 Go to previous message
nisha22
Messages: 6
Registered: September 2005
Junior Member
yep oracle versions and o/s are same on source and target ya need to increase my temp space.
Previous Topic: Flash Recovery Area
Next Topic: Please vote- 1z0-032 question
Goto Forum:
  


Current Time: Sat Dec 10 07:24:13 CST 2016

Total time taken to generate the page: 0.08772 seconds