ADDM report [message #487029] |
Wed, 22 December 2010 01:24  |
gkrishn
Messages: 506 Registered: December 2005 Location: Putty a dark screen
|
Senior Member |
|
|
Using 13,143,097 for database Id
Using 1 for instance number
:dbid := 13,143,097;
*
ERROR at line 2:
ORA-06550: line 2, column 26:
PLS-00103: Encountered the symbol "," when expecting one of the following:
i am generating addm report and dbid is not geting value as database id is coming with commas. Whts the setting to remove it.
Thanks
|
|
|
|
Re: ADDM report [message #487040 is a reply to message #487037] |
Wed, 22 December 2010 02:15   |
gkrishn
Messages: 506 Registered: December 2005 Location: Putty a dark screen
|
Senior Member |
|
|
Thanks, but ..
SQL> alter session set nls_numeric_characters='. ';
Session altered.
SQL> select dbid from DBA_HIST_DATABASE_INSTANCE;
13,143,097
13,143,097
|
|
|
|
|