Home > Imp 00003 Oracle > Imp-00003 Oracle Error 2298 Encountered

Imp-00003 Oracle Error 2298 Encountered

How can I resolve this problem? Either drop the tables in the user you importing into or update the table defintions to match the user you are exporting from. Alain Jun 21, 2011 2:23 PM I exported a datafile from a prod database : set NLS_LANG=AMERICAN_AMERICA.AL32UTF8 exp userid=borabiec file=toto.dmp (export ended without warnings, 4.6 Gb file) => then on 11gXE Get 1:1 Help Now Advertise Here Enjoyed your answer? Check This Out

Report message to a moderator Previous Topic: SQL Loader - Excel file different column order format Next Topic: Hot backup of tablespaces Goto Forum: - SQL importing table "X" 127136 rows imported . . importing table "QRTZ_SIMPLE_TRIGGERS" 0 rows imported . . importing table "ABIEC_ORDER_DETAIL" 4055 rows imported IMP-00017: following statement failed with ORACLE error 1917: "GRANT SELECT ON "ABIEC_ORDER_DETAIL" TO "ABIEC"" IMP-00003: ORACLE error 1917 encountered ORA-01917: user or role 'ABIEC' does

Home | Invite Peers | More Oracle Groups Your account is ready. Install Grid Infrastructure for standalone server + Database and Create database by... importing table "QRTZ_BLOB_TRIGGERS" 0 rows imported . . the documentpages(parent table) hold reltaed record from diffrent tables, however the record in question is 339442. 0 Message Author Comment by:salasadi2006-06-18 JJ, thanks for your comment, you shed the light

  1. importing table "ABIEC_LOCKS" 4 rows imported . .
  2. importing table "ABIEC_PASSPORT" 1312457 rows imported IMP-00017: following statement failed with ORACLE error 1917: "GRANT SELECT ON "ABIEC_PASSPORT" TO "ABIEC"" IMP-00003: ORACLE error 1917 encountered ORA-01917: user or role 'ABIEC' does
  3. It is having parent keys.Thanks,Surendra--Please see the official ORACLE-L FAQ: http://www.orafaq.net--Author:INET: Surendra.Tirumala_at_mail.state.ky.usFat City Network Services -- 858-538-5051 http://www.fatcity.comSan Diego, California -- Mailing list and web hosting services---------------------------------------------------------------------To REMOVE yourself from this

HTH Adrian Top Best Answer 0 Mark this reply as the best answer?(Choose carefully, this can't be changed) Yes | No Saving... The table may be referencing a table in another schema. 0 LVL 6 Overall: Level 6 Databases 1 Message Accepted Solution by:JJSmith2006-06-18 It may be that the data was not i.e we have to perform import twice. If the query falls over because it can't access both tables - then that could be your problem!!

You mayalso send the HELP command for other information (like subscribing). exp system/[email protected] full=y file=c:\x.dmp log=error.log but when I try import this dmp, I get these errors: imp system/[email protected] fromuser=tom touser=sam file=c:\x.dmp log=error_imp.log IMP-00019:row rejected due oracle error 1401 IMP-00003racle error 1401 Solve problems - It's Free Create your account in seconds E-mail address is taken If this is your account,sign in here Email address Username Between 5 and 30 characters. http://www.dbasupport.com/forums/showthread.php?37046-error-import-after-full-export I have sent them all theinformation they have asked for.Thanks,Surendra-----Original Message-----Sent: Wednesday, July 09, 2003 11:59 AMTo: Multiple recipients of list ORACLE-LI did that already.

importing table "ABIEC_BUNDLE" 3508 rows imported IMP-00017: following statement failed with ORACLE error 1917: "GRANT SELECT ON "ABIEC_BUNDLE" TO "ABIEC"" IMP-00003: ORACLE error 1917 encountered ORA-01917: user or role 'ABIEC' does Please type your message and try again. Is there anything harm to the database or I can to do cure. Please turn JavaScript back on and reload this page.Search this communityOracle CommunityBridged communitiesOracle BlogsOracle University TrainingOracle VideosOTN DocumentationOTN Search ResultsSearch forSearch forContentSearch forPeopleSearch forPlacesLast modifiedLast modifiedAll timeLast modified1 dayLast modified7 daysLast

importing SYSTEM's objects into SYSTEM. https://community.oracle.com/thread/2243440 importing SQLTXPLAIN's objects into SQLTXPLAIN. importing table "ABIEC_HISTORY_VET" 3334 rows imported IMP-00017: following statement failed with ORACLE error 1917: "GRANT SELECT ON "ABIEC_HISTORY_VET" TO "ABIEC"" IMP-00003: ORACLE error 1917 encountered ORA-01917: user or role 'ABIEC' does Members Search Help Register Login Home Home» RDBMS Server» Server Utilities» ORA-02298: - parent keys not found (10.2.0.2.0,unix) Show: Today's Messages :: Show Polls :: Message Navigator E-mail to friend

Reply With Quote Page 1 of 2 12 Last Jump to page: Quick Navigation Oracle Database Administration Top Site Areas Settings Private Messages Subscriptions Who's Online Search Forums Forums Home Forums his comment is here importing table "ABIEC_PAYMENT" 3230 rows imported IMP-00017: following statement failed with ORACLE error 1917: "GRANT SELECT ON "ABIEC_PAYMENT" TO "ABIEC"" IMP-00003: ORACLE error 1917 encountered ORA-01917: user or role 'ABIEC' does ORA-02298: cannot validate (string.string) - parent keys not found Cause: an alter table validating constraint failed because the table has orphaned child records. Converting to AL32UTF8 Character Set from the Oracle Default of WE8MSWIN1252 Scenario Current database uses WE8MSWIN1252 we need to migrate new database uses AL32UTF8 encoding.

importing table "ABIEC_PRODUCT_PRICE" 4 rows imported IMP-00017: following statement failed with ORACLE error 1917: "GRANT SELECT ON "ABIEC_PRODUCT_PRICE" TO "ABIEC"" IMP-00003: ORACLE error 1917 encountered ORA-01917: user or role 'ABIEC' does If you have constraints to care about you'll have to ensure that no changes happen during export or use this mode to run the export in the appropriate consistency level. MS SQL Server Databases How to create and manage Databases with phpMyAdmin in cPanel Article by: Ajit Creating and Managing Databases with phpMyAdmin in cPanel. this contact form Create the missing parent records in the parent table (foreign key relationship), and then re-execute the ALTER TABLE ENABLE CONSTRAINT command.

Connected to: Oracle Database 11g Express Edition Release 11.2.0.2.0 - 64bit Bet a Export file created by EXPORT:V10.02.01 via conventional path Warning: the objects were exported by BORABIEC, not by you It says to import as system/password.Thanks for your help.Ragz HAL9000 View Member Profile Jul 5 2009, 05:00 PM Post #4 Advanced Member Group: Members Posts: 884 Joined: 25-September 07 Member No spaces please The Profile Name is already in use Password Notify me of new activity in this group: Real Time Daily Never Keep me informed of the latest: White Papers

importing table "ABIEC_HISTORY_REFUGE" 0 rows imported . .

Tomaž "A common mistake that people make when trying to design something completely foolproof is to underestimate the ingenuity of complete fools" - Douglas Adams Reply With Quote 06-23-2003,10:12 AM #8 importing SYSTEM's objects into SYSTEMIMP-00017: following statement failed with ORACLE error 6550: "BEGIN " "declare" " dummy integer;" " begin" " select 1 into dummy from dual " " where exists Join the community of 500,000 technology professionals and ask your questions. pvr_prasad replied May 2, 2005 I can't reimport as it is production database.

Start a new thread here 723808 Related Discussions Export and import PRODUCTION: Issue with EXP & IMP. See http://www.dba-oracle.com/t_import_impdp_i...mance_speed.htmSee here for some migration tips - http://www.dba-oracle.com/t_migration_error_message_tips.htm -------------------- BrianOracle DBA Ragz View Member Profile Jul 5 2009, 03:15 PM Post #3 Newbie Group: Members Posts: 5 Joined: 1-July importing table "ABIEC_CERTIFICATE" 1198001 rows imported IMP-00017: following statement failed with ORACLE error 1917: "GRANT SELECT ON "ABIEC_CERTIFICATE" TO "ABIEC"" IMP-00003: ORACLE error 1917 encountered ORA-01917: user or role 'ABIEC' does http://wiiplay.net/imp-00003-oracle/imp-00003-oracle-error-604-encountered.html Advanced Search Forum Oracle Forums Oracle Database Administration error import after full export If this is your first visit, be sure to check out the FAQ by clicking the link above.

This tool uses JavaScript and much of it will not work correctly without it enabled. No error in alert_XE.log 2. importing table "ABIEC_HISTORY_CERT" 0 rows imported IMP-00017: following statement failed with ORACLE error 1917: "GRANT SELECT ON "ABIEC_HISTORY_CERT" TO "ABIEC"" IMP-00003: ORACLE error 1917 encountered ORA-01917: user or role 'ABIEC' does