I tried to import a dmp file that was exported before, but it failed due to this error :
Master table "PRODDTA"."SYS_IMPORT_FULL_06" successfully loaded/unloaded import done in AL32UTF8 character set and AL16UTF16 NCHAR character set export done in WE8MSWIN1252 character set and AL16UTF16 NCHAR character set Warning: possible data loss in character set conversions Starting "PRODDTA"."SYS_IMPORT_FULL_06": PRODDTA/****** Processing object type SCHEMA_EXPORT/USER ORA-39083: Object type USER:"PRODDTA" failed to create with error: ORA-65096: invalid common user or role name**
I have created the user PRODDTA and granted all the privileges, but still it did not work, I don't know if it has a problem with schema or something. I am not very familiar with Oracle, hope you can help !