I will try to explain the situation and hope that someone could help me . Sorry for my bad english.
Db version: 9.2.0.6
OS: Solaris 10 sparc
I have a production database that has a big issue. All the users I try to create don't have any privileges on his own schema.
I gave all the permissions and still can't do anything. Older schemas can't do anything in his own objects too.
The permissions of sys and system are a little mess to. I don't know what happened, but I got this problem, that is too old and I don't have backup.
I try to exp the schemas as sysdba but something goes wrong and give me errors.
I can migrate the data by creating a database link and doing create table as select. But and the others objects?
MOS is don't giving me any solution, my SR is open like 3 weeks.
Thanks in advance.