I am using Oracle 18.104.22.168 at home on SS20 solaris 8. I wanted to change the characterset of my DB to UTF8. I found this procedure to do it but it did something for a while and then stalled. Now I am not sure how to come out of it. Can anyone give me some way as to how I can abort this process or get out of this since the cursor is just blinking.
SVRMGRL> startup mount
SVRMGRL> alter system enable restricted session;
SVRMGRL> alter system set job_queue_process=0; (did not work)
SVRMGRL> alter system set aq_tm_process=0 (did not work)
SVRMGRL> alter database open;
SVRMGRL> alter database character set UTF8;
SVRMGRL> shutdown immediate; -- or normal
In the cases where the new character set is not a strict superset of the original character set, a full export/import is necessary.