You might expect there to be an easy “alter sequence” command to set a sequence to a certain value, but I don’t know of one. Today I ran into a situation where I needed to set a sequence to a… Read More
ORA-14047 When trying to rename a table
A convenient way to rename tables in Oracle is to use the RENAME command. For example, However, if the object that you’re trying to rename does not exist in whatever your CURRENT_SCHEMA is currently set to, then you can’t use… Read More
ORA-01439 When trying to change CHAR to VARCHAR2
I recently had a coworker ask me about a strange situation: They were trying to modify a column on a table to go from a CHAR(4 BYTE) to a VARCHAR2(5 BYTE). Oracle, however, didn’t seem to want to cooperate. Oracle… Read More