Home » RDBMS Server » Server Utilities » Import Error
Import Error [message #250190] Mon, 09 July 2007 01:26 Go to next message
Arju
Messages: 1554
Registered: June 2007
Location: Dhaka,Bangladesh. Mobile:...
Senior Member

I had a user named 'Arju'. And I have granted only Select role permission to user 'Arju' on schema 'prod'. Then I had deleted user 'Arju'. After that I took the dump.

Then whenever I made import this database to another machine then it gives me import error

Assign role to user Arju on prod.client(all of the tables of schema prod) failed. User Arju is not exist. How I can fix this problem?
Re: Import Error [message #250197 is a reply to message #250190] Mon, 09 July 2007 01:46 Go to previous messageGo to next message
Michel Cadot
Messages: 64120
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
In addition to saying what you did, post the statements you execute. Copy and paste your log.
Quote:
it gives me import error

Which error?

Regards
Michel
Re: Import Error [message #250214 is a reply to message #250190] Mon, 09 July 2007 02:57 Go to previous messageGo to next message
Arju
Messages: 1554
Registered: June 2007
Location: Dhaka,Bangladesh. Mobile:...
Senior Member

Yeah I should be more precise.

Here is the some part the log file:

Processing object type SCHEMA_EXPORT/TABLE/GRANT/OWNER_GRANT/OBJECT_GRANT
ORA-39083: Object type OBJECT_GRANT failed to create with error:
ORA-01917: user or role 'ARJU' does not exist
Failing sql is:
GRANT SELECT ON "PROD7"."ACL" TO "ARJU"
ORA-39083: Object type OBJECT_GRANT failed to create with error:
ORA-01917: user or role 'TESTA' does not exist


I know that this error will not cause any problem to import my data. But suppose my boss said make it error free. Then the only way is how I can import so that this type of error cant come. Is it possible?

[Updated on: Mon, 09 July 2007 03:01]

Report message to a moderator

Re: Import Error [message #250230 is a reply to message #250214] Mon, 09 July 2007 03:34 Go to previous messageGo to next message
Michel Cadot
Messages: 64120
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
ignore=yes.

Regards
Michel
Re: Import Error [message #250314 is a reply to message #250230] Mon, 09 July 2007 10:58 Go to previous messageGo to next message
DreamzZ
Messages: 1666
Registered: May 2007
Location: Dreamzland
Senior Member
Quote:
But suppose my boss said make it error free

if you don't suppose that then ??? Laughing Laughing
Re: Import Error [message #250502 is a reply to message #250190] Tue, 10 July 2007 05:11 Go to previous messageGo to next message
Arju
Messages: 1554
Registered: June 2007
Location: Dhaka,Bangladesh. Mobile:...
Senior Member

Michel I am making Export /Import by empdp and impdp . Is there ignore option available?
Re: Import Error [message #250505 is a reply to message #250190] Tue, 10 July 2007 05:39 Go to previous messageGo to next message
Arju
Messages: 1554
Registered: June 2007
Location: Dhaka,Bangladesh. Mobile:...
Senior Member

Along with previous one another query , is how I can fix my problem so that in future this type of msg ( user prod 7 is not exist) when I take dump with newly imported database and would try to import in another database.
Re: Import Error [message #250588 is a reply to message #250502] Tue, 10 July 2007 10:27 Go to previous messageGo to next message
DreamzZ
Messages: 1666
Registered: May 2007
Location: Dreamzland
Senior Member
Arju wrote on Tue, 10 July 2007 04:11
Michel I am making Export /Import by empdp and impdp . Is there ignore option available?



Its replace by TABLE_EXISTS_ACTION

Quote:
TABLE_EXISTS_ACTION parameter provides four options:
1. SKIP is the default: A table is skipped if it is found to exist.
2. APPEND will append rows if the target table’s geometry is compatible.
3. TRUNCATE will truncate the table, then load rows from the source if: 1) The geometries are compatible 2) A truncate is possible; for example, it is not possible if the table is the target of referential constraints.
4. REPLACE will drop the existing table then create and load it from the source.



http://www.oracle.com/technology/tech/grid/collateral/datapump.pdf
Re: Import Error [message #250589 is a reply to message #250505] Tue, 10 July 2007 10:29 Go to previous messageGo to next message
DreamzZ
Messages: 1666
Registered: May 2007
Location: Dreamzland
Senior Member
Arju wrote on Tue, 10 July 2007 04:39
Along with previous one another query , is how I can fix my problem so that in future this type of msg ( user prod 7 is not exist) when I take dump with newly imported database and would try to import in another database.



Use REMAP_SCHEMA cluase of Data Pump.Alternative of fromuser touser..

[Updated on: Tue, 10 July 2007 10:29]

Report message to a moderator

Re: Import Error [message #250698 is a reply to message #250589] Tue, 10 July 2007 22:09 Go to previous messageGo to next message
Arju
Messages: 1554
Registered: June 2007
Location: Dhaka,Bangladesh. Mobile:...
Senior Member

DreamzZ wrote on Tue, 10 July 2007 21:29
Arju wrote on Tue, 10 July 2007 04:39
Along with previous one another query , is how I can fix my problem so that in future this type of msg ( user prod 7 is not exist) when I take dump with newly imported database and would try to import in another database.



Use REMAP_SCHEMA cluase of Data Pump.Alternative of fromuser touser..



I actually wanted not this one. I wanted how I can fix my database so that this type of inconsistency does not exist in my database.. like .....

Processing object type SCHEMA_EXPORT/TABLE/GRANT/OWNER_GRANT/OBJECT_GRANT
ORA-39083: Object type OBJECT_GRANT failed to create with error:
ORA-01917: user or role 'ARJU' does not exist
Failing sql is:
GRANT SELECT ON "PROD7"."ACL" TO "ARJU"
ORA-39083: Object type OBJECT_GRANT failed to create with error:
ORA-01917: user or role 'TESTA' does not exist


Re: Import Error [message #250699 is a reply to message #250190] Tue, 10 July 2007 22:28 Go to previous messageGo to next message
BlackSwan
Messages: 25041
Registered: January 2009
Location: SoCal
Senior Member
From where I sit you have to make 1 of 3 choices.
1) Create User or Role called "ARJU"
2) ignore the error messages during import
3) find all the GRANTS issued to ARJU & REVOKE them and then take new export
Re: Import Error [message #250857 is a reply to message #250699] Wed, 11 July 2007 11:02 Go to previous message
DreamzZ
Messages: 1666
Registered: May 2007
Location: Dreamzland
Senior Member
if the user ARJU doesn't exit in the database By using REMAP_SCHEMA clause it create the define user automatically.
Previous Topic: SQL Loader
Next Topic: Custom function in SQL Loader
Goto Forum:
  


Current Time: Tue Dec 06 10:44:19 CST 2016

Total time taken to generate the page: 0.11115 seconds