|
|
|
|
| Re: Import Error [message #250214 is a reply to message #250190] |
Mon, 09 July 2007 02:57   |
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 #250588 is a reply to message #250502] |
Tue, 10 July 2007 10:27 |
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 |
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 #250857 is a reply to message #250699] |
Wed, 11 July 2007 11:02 |
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.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
