Re: SQL INSERT FAILS - IDENTIFIER TOO LONG (ORA-00972)
Single quotes did it :(.
On 9/22/06, Niall Litchfield <email@example.com> wrote:
You've mixed the use of double and single quotes by the look of it.
On 9/22/06, Johan Muller <
> What is really causing the insert to fail? My object name is 4 characters
> long; max lenght is 30 characters. Oracle 10.2 on RHE rel 4.
> SQL> insert into test
"Backup failed : Please check /u02/backups/backups_26810.err for errors"
</snip> is probably being treated as an identifier.
(214) 676 2147 anytime.
"Democracy is two wolves and a lamb voting on what to have for lunch.
Liberty is a well-armed lamb contesting the vote." --Benjamin Franklin