Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Setting Numwidth
Hi Ravi
You can try this.
Step 1. Search for login.sql script (Usuall it will be in Oracle_home\dbs)
Step 2. Edit the script by changing Numwidth from 9 to 12 and save it.
Step 3. Login as System/manager (Password)
Step 4. Run the script.
I think it will solve your problem.
Regards
Eswar
In article <7aqtcn$2a3$1_at_mawar.singnet.com.sg>,
"Ravi" <newisp_at_singnet.com.sg> wrote:
> Hi, all,
>
> May I know how to set numberwidth to 12 digits instead of the default 9
> digits. I don't want it only for my session but for all the sessions in the
> database.
>
> Thanks.
>
> Ravi
>
>
-----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own Received on Mon Feb 22 1999 - 09:47:09 CST