| Import: giving IMP-00034: Warning: FromUser "username"not found in export file [message #73688] |
Thu, 17 June 2004 22:40  |
Milind Deshpande
Messages: 93
Registered: May 2004
|
Member |
|
|
Dear Freinds,
I am facing a problem related to Import.The problem is like this, I am having a Full database .dmp file of the database which is exported in Version 8.1.5 which I am importing in 9i.I am using Fromuser-Touser option of Import.After Importing 4-5 users from the export file it gives IMP-00034.I have tried Full db export but it was not successful.there are about 300 users in Export file .
The import script and the error for one user is given below.
imp userid=system/manager file=/home/oracle/Backup/findb21032004.dmp log=gnlfin
.log commit=y ignore=y constraints=n grants=n show=n fromuser=AST touser=AST
Connected to: Oracle9i Enterprise Edition Release 9.2.0.1.0 - Production
With the Partitioning option
JServer Release 9.2.0.1.0 - Production
Export file created by EXPORT:V08.01.05 via conventional path
import done in US7ASCII character set and AL16UTF16 NCHAR character set
export server uses US7ASCII NCHAR character set (possible ncharset conversion)
IMP-00034: Warning: FromUser "AST" not found in export file
Import terminated successfully with warnings.
Kindly,Help me on this it is urgent.
Milind.
|
|
|
|
| Re: Import: giving IMP-00034: Warning: FromUser "username"not found in export file [message #73689 is a reply to message #73688] |
Thu, 17 June 2004 23:40  |
Himanshu
Messages: 457
Registered: December 2001
|
Senior Member |
|
|
Hi,
If you are sure that usch user exists in your Dump file then this error might be a warning only.
The user must have no objects, and so is not recognised with fromuser= touser=.
To avoid this, do the following:
1) Import into an empty schema (schema3, for example).
2) Grant SELECT on schema3.table2 to schema2.
3) Log into schema2 and issue the command:
insert into table2 select * from schema3.table2.
HTH
Regards
Himanshu
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
