This content has been marked as final. Show 9 replies
Please try this (its the same but with 1 modification):
ALTER SYSTEM ENABLE RESTRICTED SESSION;
ALTER SYSTEM SET JOB_QUEUE_PROCESSES=0;
ALTER SYSTEM SET AQ_TM_PROCESSES=0;
ALTER DATABASE OPEN;
ALTER DATABASE CHARACTER SET INTERNAL_USE AR8MSWIN1256;
Why on earth are you using the undocumented INTERNAL_USE command? The name alone should strongly imply that this isn't something that normal users should be playing with. It is extremely likely that you've corrupted your database.
Do you have a backup of your database taken before you corrupted it? If so, can you restore that backup? Once you do that, tell us what character set you're starting with. If you are implying that there is existing data in the database, what character set is that data encoded with? Can you DUMP the data to verify this?
Do not waste time trying random solutions, especially the undocumented ones with INTERNAL_USE clause, which is pretty dangerous to the database, unless you use it under Oracle's supervision. There are usually supported ways to do the same thing.
As already asked, the first and most important question is: what is the previous character set of your database?
Actually i didnt work with db11g but i think this will help u specially my last post it is tested &worked for me in db10g.
Re: How can you type from RIGHT-to-LEFT (i.e. Arabic style) in Forms?