How to transfer all data from oracle 9i to oracle oracle 11g?

Asked Oct 16 '17 at 03:49

Active Oct 16 '17 at 04:30

Viewed 814 times

1.9i version command（9i version contains a user taoTest,which 11g version not contain）：

exp system/* file=d:\exp_full.dmp full=y;

2.11g version command(create taoTest user which same as 9i version)：

create user taoTest identified by taoTest; 
grant sysdba to taoTest;

3.11g version command：

 imp system/* file=d:\exp_full.dmp full=y;

Following above three commands, there is an error

“taoTest user not exist”

How to solve this problem?

edited Oct 16 '17 at 04:30

atokpas

asked Oct 16 '17 at 03:49

fangtao

your `system/*` could to be a problem. which instance is it connecting to? – Kaushik Nayak Oct 16 '17 at 04:37
Too few initial data for the analysis of the situation. Give for analysis the log of export and import. – Dmitry Demin Oct 16 '17 at 05:44
@Kaushik Nayak Execute the following commands with the database administrator privileges. "system/*" is database administrator account and it is correct. – fangtao Oct 16 '17 at 06:30
@Dmitry Demin Do you mean that show the error log ? – fangtao Oct 16 '17 at 06:32
I mean the files, import.log export.log. The last line of the export log must be Export terminated successfully without warnings. – Dmitry Demin Oct 16 '17 at 06:44
If you want to create a user with a case-sensitive name, you must change the SQL `create user "taoTest" identified by taoTest;` – Dmitry Demin Oct 16 '17 at 06:59
Check username in source DB `select * from all_users where username ='taoTest' ; ` – Dmitry Demin Oct 16 '17 at 07:01

0 Answers0