Topic: Backup & Recovery >> IMP-00017: following statement failed with ORACLE error 6550:
|
Disclaimer: The purpose of all dbapool forums including OCP and Other Oracle Certification forums is to help each other with specific issues but not to share dump and copyrighted exam content, materials or intellectual property.
You may review the entire Oracle Certification Program Candidate Agreement online Here.
|
|
|
|
| Title: IMP-00017: following statement failed with ORACLE error 6550: |
| P |
Posted: Nov 28, 2003 02:14:06 PM |
Total Post: 7
Joined: Nov, 2003
|
hello dba's !
iam new to dba admin..
i took export of my database which it is working on RH linux AS 2.1. i tried to import on windows Xp..
during this i got errors ....
Connected to: Oracle9i Enterprise Edition Release 9.0.1.1.1 - Production
With the Partitioning option
JServer Release 9.0.1.1.1 - Production
Export file created by EXPORT:V09.02.00 via conventional path
Warning: the objects were exported by DOTSOFT, not by you
import done in WE8MSWIN1252 character set and AL16UTF16 NCHAR character set
export client uses US7ASCII character set (possible charset conversion)
. importing FRS's objects into FRS
IMP-00017: following statement failed with ORACLE error 6550:
"BEGIN "
"sys.dbms_logrep_imp.instantiate_schema(schema_name=>'FRS', export_db_name=>"
"'APADB1.US.ORACLE.COM', inst_scn=>'1767299344');"
"COMMIT; END;"
IMP-00003: ORACLE error 6550 encountered
ORA-06550: line 2, column 1:
PLS-00201: identifier 'SYS.DBMS_LOGREP_IMP' must be declared
ORA-06550: line 2, column 1:
PL/SQL: Statement ignored
IMP-00017: following statement failed with ORACLE error 922:
"CREATE TABLE "AREA_TRANSFER" ("AREA_TFR_SNO" VARCHAR2(5), "FROM_EXCHANGE_CO"
"DE" VARCHAR2(6), "ITEM_FLAG" VARCHAR2(1), "UNIQUE_ID_NO" VARCHAR2(17), "OLD"
"_PHONE_NO" VARCHAR2(12), "NEW_PHONE_NO" VARCHAR2(12), "OLD_EQUIPMENT_NO" VA"
"RCHAR2(12), "OLD_VERTICAL_NO" VARCHAR2(10), "OLD_DP_TAG" VARCHAR2(13), "OLD"
"_CABINET_IN" VARCHAR2(5), "OLD_CABINET_OUT" VARCHAR2(5), "OLD_PILLAR_IN" VA"
"RCHAR2(5), "OLD_PILLAR_OUT" VARCHAR2(5), "NEW_EQUIPMENT_NO" VARCHAR2(12), ""
"NEW_VERTICAL_NO" VARCHAR2(10), "NEW_DP_TAG" VARCHAR2(13), "NEW_CABINET_IN" "
"VARCHAR2(5), "NEW_CABINET_OUT" VARCHAR2(5), "NEW_PILLAR_IN" VARCHAR2(5), "N"
"EW_PILLAR_OUT" VARCHAR2(5), "REMARKS" VARCHAR2(50)) PCTFREE 40 PCTUSED 60 "
"INITRANS 1 MAXTRANS 255 STORAGE(INITIAL 983040 FREELISTS 2 FREELIST GROUPS "
"1) TABLESPACE "FRS" LOGGING NOCOMPRESS CACHE"
IMP-00003: ORACLE error 922 encountered
.....
....
...."NO_PARSE=>TRUE); END;"
IMP-00003: ORACLE error 1 encountered
ORA-00001: unique constraint (SYS.I_JOB_JOB) violated
ORA-06512: at "SYS.DBMS_JOB", line 97
ORA-06512: at line 1
Import terminated successfully with warnings.
...
please helpme in this regard.
just tell me how i can migrate my database from
linux to windows XP...please tell me in steps...
thank u rajamahender
my mail id : rajamahender231@yahoo.com
|
|
|
 Puneet |
| Posted: Dec 09, 2003 01:42:13 PM |  |
|
Total Post: 73
Joined: Mar, 2002
|
Is this oracle apps database?
It is just warning message. You can ignore this if dont have any problem with the application.
Puneet
|
|
|
|
|
| Time Zone: EDT |
Send this thread to your friend |
|
|
|
|
Forum Rules & Description
Who Can Read The Forum? Any registered user or guest
Who Can Post New Topics? Any registered user
Who Can Post Replies? Any registered user
|
| |
Get FREE Magazines
|
Top 10 Forum User
|
| Murtuja Khokhar | 857 |
| Mohammed Taj | 746 |
| positive fanatic | 483 |
| Jayanta Sur | 479 |
| Vigyan Kaushik | 387 |
| Vinoth Kumar | 379 |
| Gopu Gopi | 350 |
| Gitesh Trivedi | 322 |
| neeraj sharma | 258 |
| Ramesh Jois | 246 |
|
|
