Error 1917 Oracle
Contents |
importing Controller Oracle database Technote (troubleshooting) Problem(Abstract) Oracle DBA tries to
Oracle Error Code 1917
import Controller user/schema into Oracle database, using a command similar oracle import error 1917 to the following: imp system/password@databasename file=exp_SOURCEUSERNAME.dmp log=DESTINATION_USERNAME-imp.log fromuser=SOURCEUSERNAME touser=DESTINATION_USERNAME DBA receives error message. Symptom Connected to: oracle error 1917 encountered Oracle9i Enterprise Edition Release 9.2.0.7.0 - Production With the Partitioning, OLAP and Oracle Data Mining options JServer Release 9.2.0.7.0 - Production Export file created by
Oracle Error 959
EXPORT:V09.02.00 via conventional path Warning: the objects were exported by ADMIN_USERNAME, not by you import done in WE8MSWIN1252 character set and AL16UTF16 NCHAR character set export client uses WE8ISO8859P1 character set (possible charset conversion) . importing SOURCEUSERNAME's objects into DESTINATION_USERNAME IMP-00017: following statement failed with ORACLE error 1917: "GRANT SELECT ON "CCOJ_ICMPNJRNLS_GTCSMMTN_ALS"
Oracle Error 942
TO "FTIQA"" IMP-00003: ORACLE error 1917 encountered ORA-01917: user or role 'FTIQA' does not exist IMP-00017: following statement failed with ORACLE error 1917: "GRANT SELECT ON "CCOJ_ICMPNJRNLS_GTCSMMTN_SM" TO "FTIQA"" IMP-00003: ORACLE error 1917 encountered ORA-01917: user or role 'FTIQA' does not exist IMP-00017: following statement failed with ORACLE error 1917: "GRANT SELECT ON "CCOJ_ICMPNJRNLS_GTCSMMTN_SMD" TO "FTIQA"" IMP-00003: ORACLE error 1917 encountered ORA-01917: user or role 'FTIQA' does not exist IMP-00017: following statement failed with ORACLE error 1917: "GRANT SELECT ON "CCOJ_ICMPNJRNLS_JRNLS_ALS" TO "FTIQA"" IMP-00003: ORACLE error 1917 encountered... Cause The environment from where the original backup (export / .DMP) file was created is using the (optional) Oracle feature which creates additional grants on objects in the Controller schema. Resolving the problem Delete the schema, then re-create a blank schema. Finally, import the user (into the new schema) but this time use the optional switch: grants=no. Steps: Modify your import script, to som
CommunityOracle User Group CommunityTopliners CommunityOTN Speaker BureauJava CommunityError: You don't have JavaScript enabled. This tool uses JavaScript and much of it will not work correctly without it enabled. Please turn JavaScript back on and reload this page. Please ora 1917 enter a title. You can not post a blank message. Please
Ora-01917 User Or Role 'oracle' Does Not Exist
type your message and try again. More discussions in Oracle Database 11g Express Edition Beta All PlacesOracle CommunityArchived ora 01917 impdp ForumsOracle Database 11g Express Edition Beta This discussion is archived 1 Reply Latest reply on Jun 21, 2011 3:09 PM by Udo trouble importing tables - missing rows? Alain Jun http://www-01.ibm.com/support/docview.wss?uid=swg21371533 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 beta april sql> create user borabiec ... default tablespace...; grant connect, resource to borabiec; alter user borabiec unlimited quota on tablespace ...; then set NLS_LANG=AMERICAN_AMERICA.AL32UTF8 imp userid=superuser file=toto.dmp ignore=y indexes=n statistics=none https://community.oracle.com/thread/2243440 fromuser=borabiec touser=borabiec Import: Release 11.2.0.2.0 - Beta on Tue Jun 21 14:06:03 2011 Copyright (c) 1982, 2009, Oracle and/or its affiliates. All rights reserved. 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 import done in US7ASCII character set and AL16UTF16 NCHAR character set import server uses AL32UTF8 character set (possible charset conversion) export client uses AL32UTF8 character set (possible charset conversion) . importing BORABIEC's objects into BORABIEC . . importing table "ABIEC_ADDRESS" 2009624 rows imported IMP-00017: following statement failed with ORACLE error 1917: "GRANT SELECT ON "ABIEC_ADDRESS" TO "ABIEC"" IMP-00003: ORACLE error 1917 encountered ORA-01917: user or role 'ABIEC' does not exist . . importing table "ABIEC_ANIMAL" 2422809 rows imported IMP-00017: following statement failed with ORACLE error 1917: "GRANT SELECT ON "ABIEC_ANIMAL" TO "ABIEC"" IMP-00003: ORACLE error 1917 encountered ORA-01917: user or role 'ABIEC' does not exist . . importing table "ABIEC_BUNDLE" 3508 rows imported IMP-00017: following statement failed with ORACLE error 1917: "G
07:58 ora_2007 Messages: 430Registered: July 2007 Location: Mumbai Senior Member I want to import 1 .dmp file into oracle database. I dont know what exactly what http://www.orafaq.com/forum/t/124966/ that .dmp file contains e.g i dont know the Users inside the dump. While importing it gives me the error. 1. Do i need to create those users first http://stackoverflow.com/questions/11185575/import-dmp-file-into-a-new-install-of-oracle-xe and then import if yes then how would i know how many users are inside that dump. 2. Currently the objects are created in SYSTEM user by default. I oracle error want to import those objects in the MACL user which i created. How can i do it? IMP-00003: ORACLE error 1917 encountered ORA-01917: user or role 'MALCCOMAN' does not exist IMP-00017: following statement failed with ORACLE error 1917: "GRANT INDEX ON "HMSTRESAVAILDTL" TO "MALCCOMAN" WITH GRANT OPTION" IMP-00003: ORACLE error 1917 encountered ORA-01917: user or role 'MALCCOMAN' does not error 1917 oracle exist IMP-00017: following statement failed with ORACLE error 1917: "GRANT INSERT ON "HMSTRESAVAILDTL" TO "MALCCOMAN" WITH GRANT OPTION" IMP-00003: ORACLE error 1917 encountered ORA-01917: user or role 'MALCCOMAN' does not exist IMP-00017: following statement failed with ORACLE error 1917: "GRANT SELECT ON "HMSTRESAVAILDTL" TO "MALCCOMAN" WITH GRANT OPTION" IMP-00003: ORACLE error 1917 encountered ORA-01917: user or role 'MALCCOMAN' does not exist IMP-00017: following statement failed with ORACLE error 1917: "GRANT UPDATE ON "HMSTRESAVAILDTL" TO "MALCCOMAN" WITH GRANT OPTION" IMP-00003: ORACLE error 1917 encountered ORA-01917: user or role 'MALCCOMAN' does not exist IMP-00017: following statement failed with ORACLE error 1917: "GRANT REFERENCES ON "HMSTRESAVAILDTL" TO "MALCCOMAN" WITH GRANT OPTION" IMP-00003: ORACLE error 1917 encountered ORA-01917: user or role 'MALCCOMAN' does not exist IMP-00017: following statement failed with ORACLE error 1917: "GRANT DELETE ON "HMSTRESAVAILDTL" TO "MALCUSRAN" WITH GRANT OPTION" IMP-00003: ORACLE error 1917 encountered ORA-01917: user or role 'MALCUSRAN' does not exist IMP-00017: following statement failed with ORACLE error 1917: "GRANT INDEX ON "HMSTRESAVAILDTL" TO "MALCUSRAN" WITH GRANT OPTION" IMP-00003: ORACLE error 1917 encountered ORA-01917:
here for a quick overview of the site Help Center Detailed answers to any questions you might have Meta Discuss the workings and policies of this site About Us Learn more about Stack Overflow the company Business Learn more about hiring developers or posting ads with us Stack Overflow Questions Jobs Documentation Tags Users Badges Ask Question x Dismiss Join the Stack Overflow Community Stack Overflow is a community of 4.7 million programmers, just like you, helping each other. Join them; it only takes a minute: Sign up import dmp file into a new install of oracle xe up vote 0 down vote favorite I'm trying to import a *.dmp file from the database of a client into a new install of Oracle XE 11.2.0. I'm new to Oracle DB, I always used MySQL, so I have searched the forum and used the command from cmd C:\oraclexe\app\oracle\product\11.2.0\server\bin>imp 'system/root AS SYSDBA' file=c:\export.dmp full=yes log=implog.txt with no luck. The implog.txt is as follows: Connected to: Oracle Database 11g Express Edition Release 11.2.0.2.0 - Production Export file created by EXPORT:V09.02.00 via conventional path import done in WE8MSWIN1252 character set and AL16UTF16 NCHAR character set import server uses AL32UTF8 character set (possible charset conversion) export client uses UTF8 character set (possible charset conversion) . importing SYSTEM's objects into SYSTEM IMP-00015: following statement failed because the object already exists: "CREATE UNDO TABLESPACE "UNDOTBS1" BLOCKSIZE 8192 DATAFILE '/home/app/oracl" "e/oradata/ANA/undotbs01.dbf' SIZE 2000M AUTOEXTEND ON NEXT 5242880 M" "AXSIZE 32767M EXTENT MANAGEMENT LOCAL " IMP-00015: following statement failed because the object already exists: "CREATE TEMPORARY TABLESPACE "TEMP" BLOCKSIZE 8192 TEMPFILE '/home2/oradata" "/ANA/temp01.d