Hi
In SQL command od Oracle 9i I look error because "_" is invalid character.

examle:
grant all on _USER_REPL_NESTED_TABLE_NAMES to baza_prog_admin
*
ERROR at line 1:
ORA-00911: invalid character


Why "_" on first character is invalid?

On Apr 1, 7:54*am, "Karol" <n... (AT) mail (DOT) com> wrote:
Because that is the syntax of identifiers. RTFM.
http://download.oracle.com/docs/cd/B...008.htm#i27570

Among the rules is this:
"Nonquoted identifiers must begin with an alphabetic character from
your database character set. Quoted identifiers can begin with any
character."

Ed

On Apr 1, 6:04*am, Ed Prochak <edproc... (AT) gmail (DOT) com> wrote:
In Standard SQL, a leading underscore has special meaning as an
'introducer'. It precedes the qualified character set name that
modifies a
following character string literal or identifier. This specifies the
character set used in the literal or identifier.

Because of the above, Standard SQL does not allow a leading underscore
for
a unquoted identifier. It's one place where Oracle complies with the
standard.

--
Lee Fesperman, FFE Software, Inc. (http://www.firstsql.com)
================================================== ============
* The Ultimate DBMS is here!
* FirstSQL/J Object/Relational DBMS (http://www.firstsql.com)