Re: SQL INSERT FAILS - IDENTIFIER TOO LONG (ORA-00972)

Single quotes did it :(.

Thks all.

On 9/22/06, Niall Litchfield <niall.litchfield_at_gmail.com> wrote:
>
> You've mixed the use of double and single quotes by the look of it.
>
> On 9/22/06, Johan Muller <johan.muller_at_gmail.com> wrote:
> > 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
> <snip>
> "Backup failed : Please check /u02/backups/backups_26810.err for errors"
> </snip> is probably being treated as an identifier.
>
> cheers
>
>
> --
> Niall Litchfield
> Oracle DBA
> http://www.orawin.info
>

-- 
Johan Muller
Oracle DBA
(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

--
http://www.freelists.org/webpage/oracle-l