SQL> shutdown abort .com

About DBA Queries DBA Scripts Quick Guides Other Stuff Contact
Andy only 
 
ORA-32021: parameter value longer than 255 characters

It is in fact possible to set parameter values larger than 255 characters. To do so you need to split the parameter up into multiple smaller strings, like this:

alter system set <parameter> = 'string1','string2' scope=both;

For more useful DBA queries click here.
Copyright© 2007-2012 Andrew Barry