| Doubt on import utility [message #288712] |
Tue, 18 December 2007 07:14  |
rolex.mp
Messages: 161
Registered: February 2007
|
Senior Member |
|
|
I want to export data from 10g release 2 database and import it into the 11g database . The database structure varies ie most of the schemas thati need to import are new ones which dont exist in the 11g database.
When I do a full database export from 10g db and then do a full database import into 11g db using datapump import I face many errors like
ORA-39083: Object type OBJECT_GRANT failed to create with error:
ORA-01917: user or role 'SH' does not exist
Failing sql is:
GRANT WRITE ON DIRECTORY "LOG_FILE_DIR" TO "SH"
So should I create the users in the target db before running the import since there are hundereds of new users and creating users will be a hectic job or did i commit any mistake in running the import utility ?
|
|
|
|
|
|
| Re: Doubt on import utility [message #288718 is a reply to message #288714] |
Tue, 18 December 2007 07:27  |
rolex.mp
Messages: 161
Registered: February 2007
|
Senior Member |
|
|
Most of the schemas are inter-dependent ... so in that case if I have to export and import each schema this has to be done a few hundered times thats why I thought may be the complete database import may ease the process .
So is it possible to import schemas which do not exist in the target database ? Will the utility create the schemas and import the schema objects ?
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
