unable to drop table created with "special" characters
Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production¶Version 19.18.0.0.0
table got created accidentally with special character.
when try to drop "abcdef_20230504ᅡ", i get error "SQL Error [942] [42000]: ORA-00942: table or view does not exist"
i tried to drop based on object id as below, still the same error
declare
tabname varchar2(100);
sql_txt varchar2(1000);
begin
select object_name into tabname from dba_objects where object_id=524635;
DBMS_OUTPUT.PUT_LINE('Selected Table :' || tabname);
sql_txt := 'Drop table "'||tabname ||'"';
execute immediate sql_txt;
end;