set ver off;
set define on;

column object_name format a30
column status format a10
column owner format a30

define propietario=&1 ;
define tipo=&2;
define nombre=&3;

select owner,object_id,DATA_OBJECT_ID,object_type,object_name,status,created,last_ddl_time
from dba_objects
where OWNER like upper('%&propietario%')
and object_type like upper('%&tipo%')
and object_name like upper('%&nombre%')
and object_type not like '%PARTITION%'
order by owner,object_type,object_name
/



set ver on;
