Deleting by ROWID

I’d like to run this query.

DELETE FROM A006873.GC_CLIENTS
WHERE ROWID = '14519';

But I get this error:

SQL.sql: Error (2,15): ORA-01410: invalid ROWID

I got in GC_CLIENTS

ID      NUMBER      NAME
14519   0000017690  VILLAVINE

I don’t realize what’s wrong if I’m in the correct ID.
I’m using a sequence by the way and I don’t want to delete it with a WHERE ID = '14519'.

Thanks.


Source: oracle

Leave a Reply