Home » RDBMS Server » Server Utilities » Import / Export
icon8.gif  Import / Export [message #223988] Mon, 12 March 2007 10:10 Go to next message
thorin666
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)
Thnx

Report message to a moderator

Re: Import / Export [message #224008 is a reply to message #223988] Mon, 12 March 2007 11:06 Go to previous message
Mahesh Rajendran
Messages: 10707
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.

Report message to a moderator

Previous Topic: Export Backup
Next Topic: ulcase files
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Tue Jul 02 15:51:48 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.