Actually, WE8ISO8859P1 *is* a superset of US7ASCII, which is how we were able to do the same ALTER DATABASE (in 8.1.7.2 at the time) you mentioned.
Check out http://metalink.oracle.com/metalink/plsql/ml2_documents.showDocument?p_id=11 9164.1&p_database_id=NOT (pasting the link together) for a list of valid supersets. Your combo is sixth in the list. Rich Rich Jesse System/Database Administrator [EMAIL PROTECTED] Quad/Tech Inc, Sussex, WI USA > -----Original Message----- > From: Thomas Day [mailto:[EMAIL PROTECTED] > Sent: Wednesday, October 22, 2003 12:34 PM > To: Multiple recipients of list ORACLE-L > Subject: Change Character sets > > > > I have a database that was populated using an export from an US7ASCII > Oracle database. The current database is WE8ISO8859P1 which is not a > superset of US7ASCII. So I can't change the characterset > using the ALTER > DATABASE as the manual suggests. The alternative is to export the > database, drop the current instance, create a new instance > with the correct > characterset and import the old database. > > But I know that there is no data in the database that was not > supported in > the US7ASCII database. Is there a shortcut? The UPDATE > sys.PROPS$ trick > is a no-go. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jesse, Rich INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
