in a PDB I have created a user, import a backup then trying to create drop statement for some object types to clean (backup import using impdp)
select 'drop '||object_type||' '|| object_name|| DECODE(OBJECT_TYPE,'TABLE',' CASCADE CONSTRAINTS','') || ';' from user_objects where object type in ('TABLE','INDEX','FUNCTION','PROCEDURE','SEQUENCE','PACKAGE','PACKAGE BODY','VIEW','TYPE','SYNONYM');
and its throwing errors (mostly showing error: ORA-65040: operation not allowed from within a pluggable database )
it was imported directly within a PDB then why this error? how I can fix this?
please help.
with kind regards