I have an issue when trying to change the character set on an Oracle 11.2 database.
Here are the particulars:
- Oracle 11.2 64 bit, running under Oracle Linux 7
- This is a new installation (i.e. the only users are those that were created during the Oracle install), using the defaults given during the Oracle installation
- The current NLS_CHARACTERSET is AL32UTF8, and I need to convert it to either WE8MSWIN1252 or WE8DEC
Most of my experience with Oracle has been with Windows, and I've never had to change the character sets before.
Now I can't just change the character set from AL32UTF8 to WE8DEC or WE8MSWIN1252 because those aren't supersets. So, I ran CSINST.SQL, and ran the CSSCAN command. Most of the scan was successful, but I ended up receiving the following errors:
. processs 1 scanning XDB.PRIN_PT[AAAN9DAACAAAEGoAAA]
ORA-30967: operation directly on the Path Table is disallowed
CSS-00144: failed to scan table XDB.PRIN_PT
Does anyone have any idea what the problem can be and/or how to fix it?
I've done some searching.I did find someone who has mentioned deleting and recreating XML indexes, but I've never done that.