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

  • From: "Johan Muller" <johan.muller@xxxxxxxxx>
  • To: "Niall Litchfield" <niall.litchfield@xxxxxxxxx>
  • Date: Fri, 22 Sep 2006 09:28:48 -0400

Single quotes did it :(.

Thks all.

On 9/22/06, Niall Litchfield <niall.litchfield@xxxxxxxxx> wrote: 

You've mixed the use of double and single quotes by the look of it.

On 9/22/06, Johan Muller <johan.muller@xxxxxxxxx> 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

Other related posts:

  1. Home
  2. oracle-l
  3. Archive
  4. 09-2006