simple alter table add column hangs forever?
19.14 enterprise and multitenant
Linux
Hi,
This simple alter table commands hangs and never seems to finish:
ALTER TABLE USER.TABLE1 ADD PRINT_CODE VARCHAR(1 CHAR);
There are no locks on the table, its around 6000 rows. Query did not finish in 20 minutes.
Any ideas?
Regards
WestCoast_DBA