failed with oracle error 1917 Grethel Kentucky

Address Computers, Campton, KY 41301
Phone (606) 668-6949
Website Link
Hours

failed with oracle error 1917 Grethel, Kentucky

In other words: exp/imp is an all or nothing recovery. importing table "ABIEC_LOCKS" 4 rows imported . . What im trying to do is either get his data to fill my tables or to import his full database into mine. importing table "T0414_1514" 3628 rows imported . .

How do I explain that this is a terrible idea? 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 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 IMP-00003: ORACLE error 1917 encountered Melanie Antonio asked May 31, 2007 | Replies (1) I am restoring a database and created my users before importing.

Isn't that more expensive than an elevated system? 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 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 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

share|improve this answer answered Jun 25 '12 at 8:23 arnep 3,69931939 @amep - I'd see which tablespaces are actually required and only create those; from the log I'd guess The time now is 08:56 AM. You can find more information about Oracle's import and export utilities here: http://download-west.oracle.com/docs/cd/B10501_01/server.920/a96652/part1.htm Like Show 0 Likes(0) Actions 6. exporting operators .

importing table "TATTOOASSOCIATION" 0 rows imported . . about to export DBSNMP's tables via Conventional Path ... . I'm able to connect to the database Via Sqlplus and other oracle tools. importing table "ABIEC_HISTORY_REFUGE" 0 rows imported . .

I want to import those objects in the MACL user which i created. You can then extract the text to create the tablespaces. If you can afford to lose data from the time of the last export until restore, then it's OK. Privacy Policy Site Map Support Terms of Use Skip navigationOracle Community DirectoryOracle Community FAQLog inRegisterMy Oracle Support Community (MOSC)SearchSearchCancelGo Directly To Oracle Technology Network CommunityMy Oracle Support CommunityOPN Cloud ConnectionOracle Employee

In your case it may be that all the A00-owned objects are in the A00 tablespace, but you'll need to check. 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. Here it seems a unix path... -almost everywhere Oracle says it can't create users/tables/indexes because they already exist.. The error I get is this: Export file created by EXPORT:V09.02.00 via conventional path import done in WE8MSWIN1252 character set and AL16UTF16 NCHAR character set export client uses WE8ISO8859P1 character set

Subscribe to our monthly newsletter for tech news and trends Membership How it Works Gigs Live Careers Plans and Pricing For Business Become an Expert Resource Center About Us Who We current community chat Stack Overflow Meta Stack Overflow your communities Sign up or log in to customize your list. If the users or roles needed to exist in this database and the export was a user level export (import command had the parameter owner=) you need to create the users If you have done this then just let import going, the errors you are getting would be just warnings Reply With Quote 02-04-2001,04:37 PM #8 treedstang View Profile View Forum Posts

Import terminated successfully with warnings. importing table "ABIEC_HISTORY_PP" 137817 rows imported IMP-00017: following statement failed with ORACLE error 1917: "GRANT SELECT ON "ABIEC_HISTORY_PP" TO "ABIEC"" IMP-00003: ORACLE error 1917 encountered ORA-01917: user or role 'ABIEC' does Currently the objects are created in SYSTEM user by default. As the DBA, if you don't know them, who does?

File has an Oracle Managed Files file name. I am forced to support few leftover oracle db's here. From the export log that looks like A00, D00 or both. 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

Login SearchOracle SearchDataManagement SearchBusinessAnalytics SearchSAP SearchSQLServer TheServerSide SearchDataCenter SearchContentManagement SearchFinancialApplications Topic Backup and recovery Database Admin View All Cloud infrastructure Availability Database design Export, import and migration Installation, upgrades and patches This tool uses JavaScript and much of it will not work correctly without it enabled. 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 Is there a way I can create a new database from the existing DMP file.

Resolving the problem Delete the schema, then re-create a blank schema. Re: .dmp file 473871 Dec 3, 2005 12:26 AM (in response to 437966) I know I wasn't the one that started this, but I was need this same answer. exporting PUBLIC type synonyms . Solved Oracle Full Import Error Posted on 2010-03-05 Oracle Database 1 Verified Solution 16 Comments 2,841 Views Last Modified: 2012-06-27 Oracle 10g on Win 2003 Server I got the below errors

importing table "ABIEC_ORDER" 3565 rows imported IMP-00017: following statement failed with ORACLE error 1917: "GRANT SELECT ON "ABIEC_ORDER" TO "ABIEC"" IMP-00003: ORACLE error 1917 encountered ORA-01917: user or role 'ABIEC' does Anyway, you can tell imp to generate output and not really do anything. Re: .dmp file Hans Forbrich Dec 2, 2005 9:20 PM (in response to 460133) IF the dump file was created using Oracle's export command, the import is done at command line