| dump-import [message #61243] |
Wed, 07 April 2004 06:18  |
fm
Messages: 1
Registered: April 2004
|
Junior Member |
|
|
Hi,
there is a problem concerning an import of a dump exported from a database on 7.3.4 to a Database on version 8.1.7.
I whish to import tables only (Option TABLES=*). So dump-file is created with tables-option only already.
The problem is, the export is done from a user different to the import-user. So I did activate the option "FROMUSER=..." TOUSER='...' ('...' means username). But the import causes conflicts for every table like:
"GRANT INSERT ON "CLIENT" TO "EDV_WRITE", ORA-01917: Benutzer oder Funktion EDV_WRITE existiert nicht
What can I do to avoid such conflicts?
A lot of thanks for help.
fm
|
|
|
|
|
|
| Re: dump-import [message #61247 is a reply to message #61243] |
Wed, 07 April 2004 20:45  |
Anatol Ciolac
Messages: 113
Registered: December 2003
|
Senior Member |
|
|
|
This error show that your have not a user EDV_WRITE so if you need you must to create them, or , as said Mahesh user grants=n or to not pay attention to this warning.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
