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

From: Niall Litchfield <niall.litchfield_at_gmail.com>
Date: Fri, 22 Sep 2006 14:27:12 +0100
Message-ID: <7765c8970609220627kc57f27cx51854a31cc24a1f3@mail.gmail.com>

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
--
http://www.freelists.org/webpage/oracle-l

Received on Fri Sep 22 2006 - 08:27:12 CDT