Home > Failed With > Ora-01917 User Or Role 'oracle' Does Not Exist
Ora-01917 User Or Role 'oracle' Does Not Exist
The first thing you need to find out is which schemas (users) you need to recreate. File has an Oracle Managed Files file name. Both resulted errors. How to mount a disk image from the command line? Check This Out
is there something to recognize the owner of the tablespace? –Andrea Jun 25 '12 at 10:14 @Andrea - you won't be able to read the file anyway, at least I'll add an answer suggesting something you can try, but you'll need to know which user(s)'s data you want. Report message to a moderator import [message #596635 is a reply to message #348334] Wed, 25 September 2013 05:47 ellareddy Messages: 1Registered: October 2012 Location: hyd Junior Member exporting sequence numbers .
Ora-01917 User Or Role 'oracle' Does Not Exist
You can view that file in notepad or some other text editor, and search for all the TABLESPACE references. I used the default preconfigured database setup. Other wise, you should ask your friend which user the desired schema was created under and when prompted if you want to import all data, answer 'no' and then enter the
- After the first fail I tried to log in as SYSTEM, couldn't so I deleted Oracle XE and reinstalled from scratch, so I think it's a fresh install.
- File has an Oracle Managed Files file name.
- Re: .dmp file Hans Forbrich Dec 2, 2005 9:21 PM (in response to Hans Forbrich) ANd in case I was not clear - command line means 'DOS' not SQLPlus ...
- Like Show 0 Likes(0) Actions 2.
- First determine in they are are users or roles by query dba_users and dba_roles in the database that the export was created from.
- IMP-00015: following statement failed because the object already exists: "CREATE TABLESPACE "USERS" BLOCKSIZE 8192 DATAFILE '/home/app/oracle/oradat" "a/ANA/users01.dbf' SIZE 1048576 AUTOEXTEND ON NEXT 1310720 MAXSIZE 3" "2767M EXTENT MANAGEMENT LOCAL AUTOALLOCATE ONLINE
- 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.
- I am forced to support few leftover oracle db's 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
exporting PUBLIC type synonyms . Can we use this as a backup strategy. exporting cluster definitions . I have precreated the tablespaces and it import went through fine.
Currently the objects are created in SYSTEM user by default. Ora-1917 How to deal with players rejecting the question premise Are there any rules or guidelines about designing a flag? Edited by: Alain on 21 juin 2011 07:20 I have the same question Show 0 Likes(0) 760Views Tags: none (add) This content has been marked as final. http://searchoracle.techtarget.com/answer/How-to-solve-an-Oracle-import-error Top This thread has been closed due to inactivity.
Since there's a bug and you can't do a full, what method do you want to pursue? 1: create script to precreate tablespaces, keep up to date as you add tablespaces, exporting post-schema procedural objects and actions . I want to import those objects in the MACL user which i created. I just couldn't get it to work in one step.
importing table "ROLL" 1 rows imported IMP-00017: following statement failed with ORACLE error 1917: "GRANT ALTER ON "ROLL" TO "APEREZ"" IMP-00003: ORACLE error 1917 encountered ORA-01917: user or role 'APEREZ' does http://www.dbasupport.com/forums/showthread.php?6475-IMPORT-PROBLEMS-WITH-DUMP-FILE importing table "ABIEC_PERSON_ID" 2040070 rows imported IMP-00017: following statement failed with ORACLE error 1917: "GRANT SELECT ON "ABIEC_PERSON_ID" TO "ABIEC"" IMP-00003: ORACLE error 1917 encountered ORA-01917: user or role 'ABIEC' does Ora-01917 User Or Role 'oracle' Does Not Exist IMP-00017: following statement failed with ORACLE error 2298: "ALTER TABLE "ABIEC_PERSON" ENABLE CONSTRAINT "FK54498ACE172FE4E6"" IMP-00003: ORACLE error 2298 encountered ORA-02298: cannot validate (BORABIEC.FK54498ACE172FE4E6) - parent keys not found IMP-00017: following statement If the users or roles are not needed you can set the parameter grants=n in the import statement to skip the grants.
importing table "ABIEC_DOG_ID" 2465421 rows imported IMP-00017: following statement failed with ORACLE error 1917: "GRANT SELECT ON "ABIEC_DOG_ID" TO "ABIEC"" IMP-00003: ORACLE error 1917 encountered ORA-01917: user or role 'ABIEC' does Im fairly new to oracle and have just been learning SQL so if someone can give me a step by step way of importing the file then please do so. Anyone got any ideas ? Why are so many metros underground?
Forum FAQ Calendar Forum Actions Mark Forums Read Quick Links View Site Leaders Who's Online What's New? should then build OK, and the data will be imported into them. exporting statistics Export terminated successfully without warnings. this contact form Connected to: Oracle Database 11g Express Edition Release 188.8.131.52.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
Oracle Database AWS Cloud Services Perl Using the Oracle Datapump Export and Import Utilities Video by: Steve This video shows how to Export data from an Oracle database using the Datapump 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 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
share|improve this answer answered Jun 25 '12 at 10:51 Alex Poole 86.6k55893 Thank you for your suggestions, I made it.
can you give an advice on this? You can not post a blank message. Seem strange the only thing I can connect to the imported database with is oracle tools only any reason why? about to export OUTLN's tables via Conventional Path ... .
Check out Metalink note: 734681.1. Featured Post How to run any project with ease Promoted by Quip, Inc Manage projects of all sizes how you want. Try pre-creating the tablespaces. 0 LVL 15 Overall: Level 15 Oracle Database 15 Message Expert Comment by:Devinder Singh Virdi2010-03-05 >> expdp 'sys/@SMSI as sysdba' directory=data_pump_dir FULL=y DUMPFILE=SMSI.dmp LOGFILE=SMSI.log >> U:\>imp navigate here I have mentioned to use 8i binaries for imp.
You can then extract the text to create the tablespaces. importing WMSYS's objects into WMSYS . All rights reserved. To start viewing messages, select the forum that you want to visit from the selection below.
Database Journal | SQLCourse | SQLCourse2 Register Help Remember Me? exporting dimensions . Please enter a title. Check out Metalink note: 734681.1.
If you look, you'll see all the object created in the schema you did the import as. importing table "ADMIN_ANALYZE" 2 rows imported IMP-00017: following statement failed with ORACLE error 1917: "GRANT SELECT ON "ADMIN_ANALYZE" TO "TRI_READ_ROLE"" IMP-00003: ORACLE error 1917 encountered ORA-01917: user or role 'TRI_READ_ROLE' does Advanced Search Forum Archives Forum Archives IMPORT PROBLEMS WITH DUMP FILE If this is your first visit, be sure to check out the FAQ by clicking the link above. What kind of bicycle clamps are these?
If small, then you can take export of every schema instead of whole database. 0 LVL 8 Overall: Level 8 Message Author Comment by:dba2dba2010-03-05 The database is around 5 GB You export say at 10:00 PM. Besides this way they would also need a build script for the users/roles/???. 0 LVL 76 Overall: Level 76 Oracle Database 74 Message Active 1 day ago Expert Comment by:slightwv importing SYSMAN's objects into SYSMAN .
share|improve this answer answered Jun 25 '12 at 8:21 rfranr 563 It seems a bit strange to me also, but when in the office of the client I used the options can be used to just extract the definitions, suppress/allow dups, move to a different userid, etc. Since it's almost done should I let it keep going? I am new to oracle dba.