Way to easily run the same query in Toad against multiple Oracle database servers

ORA-15041: diskgroup space exhausted

Seems like you're using ASM to store your archivelogs/backups and you have probably filled it up (probably because old backups are not getting purged)

As cagcowboy has told you you're database is probably hung because it cannot archive and switch its current logfile but does not seem you have to recover/restore or something. Once you are able to free up some space the instance will continue its activity.

As already suggested, I should try to get in touch with Oracle support to get proper advise.

Regards.

You should have two choices to make :

1. Choose your database character set (used by VARCHAR2, CHAR, CLOB datatypes).
2. Choose your national character set (used by NVARCHAR2, NCHAR, NCLOB datatypes).

As seen here :

Oracle recommends using Unicode for all new system deployments.

National character sets can only be Unicode : UTF-8 or UTF-16. So choosing the same character set for both would be redundant...

My advice (you say your application is in English only) :

• Ask for your database character set to be UTF-8.
• Ask for your national character set to be UTF-16.

And here is my general advice for your schema definition. Table by table, column by column (I take the VARCHAR2/NVARCHAR2 sample here) :

• if your column could contain any character in the world (as in user input), make it NVARCHAR2.
• if you have control about what is going to be stored (English then), make it VARCHAR2.