I have done exp from schema-1 and tried to import into schema-2 of the same db. while import I am getting the following error i have the dba privilege on the user id, why this char set problem, i understood that the charset is database level, if I am right why the error when using the same database. Can some one help me to resolve this problem.
Export file created by EXPORT:V09.02.00 via conventional path
import done in US7ASCII character set and AL16UTF16 NCHAR character set
import server uses WE8ISO8859P1 character set (possible charset conversion)
IMP-00007: must be a DBA to import objects to another user's account
IMP-00000: Import terminated unsuccessfully
The privileges needed to import into another user's account do not exist. Only a database administrator can import into another user's account. To ensure you have all the right DBA privileges compare what the SYSTEM user has that you do not have.