Home » RDBMS Server » Server Utilities » Doubt on import utility
Doubt on import utility [message #288712] Tue, 18 December 2007 07:14 Go to next message
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 #288714 is a reply to message #288712] Tue, 18 December 2007 07:19 Go to previous messageGo to next message
Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE
Senior Member

But why you want to export full database from 10g ???

If you want to export/import between 10g to 11g then just export require schemas instead of all.
Re: Doubt on import utility [message #288718 is a reply to message #288714] Tue, 18 December 2007 07:27 Go to previous messageGo to next message
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 ?
Re: Doubt on import utility [message #288723 is a reply to message #288718] Tue, 18 December 2007 07:36 Go to previous message
Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE
Senior Member

Yes full database export created all required tablespace / schemas during import operation.
Previous Topic: Full DB Export Session Hanged
Next Topic: EXP Error
Goto Forum:
  


Current Time: Mon Dec 05 12:58:49 CST 2016

Total time taken to generate the page: 0.06772 seconds