Skip to Content
0
Former Member
Aug 10, 2010 at 01:29 PM

Unable to Alter the user

220 Views

Hi All,

I am trying to alter a user but unable to do it.

When i type the following command

SQL> select username from dba_users where default_tablespace='_$deleted$6$0';

USERNAME

-


OM?V

M?DO

KRB?

HE?K

CHM?

ALK?

TOS?

VI?K

?SLI

9 rows selected.

and when i execute

SQL> alter user "OM?V" default tablespace PROTASTAB;

alter user "OM?V" default tablespace PROTASTAB

*

ERROR at line 1:

ORA-01918: user 'OM?V' does not exist

SQL> alter user 'OM?V' default tablespace PROTASTAB;

alter user 'OM?V' default tablespace PROTASTAB

*

ERROR at line 1:

ORA-01935: missing user or role name

SQL> alter user OM?V default tablespace PROTASTAB;

alter user OM?V default tablespace PROTASTAB

*

ERROR at line 1:

ORA-00911: invalid character

and i am not sure how to fix it. Please advise.

Regards,

-Addi-