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

  • From: "Niall Litchfield" <niall.litchfield@xxxxxxxxx>
  • To: johan.muller@xxxxxxxxx
  • Date: Fri, 22 Sep 2006 14:27:12 +0100

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


Other related posts: