Database Administration (MOSC)

MOSC Banner

unable to drop table created with "special" characters

edited Jul 13, 2023 1:38AM in Database Administration (MOSC) 3 commentsAnswered

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;

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center