Re: SQL INSERT FAILS - IDENTIFIER TOO LONG (ORA-00972)
You've mixed the use of double and single quotes by the look of it.
On 9/22/06, Johan Muller <johan.muller@(protected):
> 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.