Home » RDBMS Server » Server Utilities » Import / Export
icon8.gif  Import / Export [message #223988] Mon, 12 March 2007 10:10 Go to next message
Messages: 144
Registered: March 2007
Senior Member

Hi i am exporting full database from oracle8 to oracle10g
My problem is that when i am importing into oracle10g, there is an error that cant grant privilegies because the user dont exist, but if i am exporting everything, why this error occurs?
May i create all users before do the import? (there are more than 500 users :S)

Pd i am using sqlplus/debian (not OEM, toad and that kind of tools)
Re: Import / Export [message #224008 is a reply to message #223988] Mon, 12 March 2007 11:06 Go to previous message
Mahesh Rajendran
Messages: 10677
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
There are several system created users in 8i ( because of the OPTIONS you chose) that may not be available in 10g (again because of the OPTIONS you chose).
Go through the list of users in 8i and see if they are still applicable in 10g.
Previous Topic: sql loader and foreign keys
Next Topic: ulcase files
Goto Forum:

Current Time: Wed Aug 23 09:03:11 CDT 2017

Total time taken to generate the page: 0.04629 seconds