SQL Language (MOSC)

MOSC Banner

Drop Table Patition

edited Jul 15, 2013 3:13AM in SQL Language (MOSC) 4 commentsAnswered ✓
 hi, 
I need to delete some audit tables, but when trying to delete states the following.

SQL> drop table "SYS.BIN$zfB6pVncR6zgRAAhKA1jjg==$0";
drop table "SYS.BIN$zfB6pVncR6zgRAAhKA1jjg==$0"
           *
ERROR at line 1:
ORA-00972: identifier is too long

also use

SQL> drop table "SYS.BIN$zfB6pVncR6zgRAAhKA1jjg==$0" purge;
drop table "SYS.BIN$zfB6pVncR6zgRAAhKA1jjg==$0" purge
           *
ERROR at line 1:
ORA-00972: identifier is too long


how could I do this??'

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