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: 10672
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: Export Backup
Next Topic: ulcase files
Goto Forum:

Current Time: Tue Oct 25 20:13:43 CDT 2016

Total time taken to generate the page: 0.05231 seconds