Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Failed when executing ALTER DATABASE

124626Feb 28 2004 — edited Feb 28 2004

I am trying to convert the character set from US7ASCII to WE8MSWIN1252. I connect through sql and start the database in restricted mode.

I then execute the following command:

alter database character set internal_use WE8MSWIN1252

But every time I do this, I get the following message:

ORA-12721: operation cannot execute when other sessions are active

When the database is started in restricted mode, any mode actually, there is always 8 background processes actively running. I cannot seem to kill those sessions which seem to be preventing the alter database command to execute.

I am on a Windows box if that is of any help.

Thanks in advance for any feedback.

Locked Post

New comments cannot be posted to this locked post.

Locked on Mar 27 2004

Added on Feb 28 2004

#database-key-features, #globalization-support

4 comments

725 views