select a.owner,a.OBJECT_NAME,a.OBJECT_TYPE,a.CREATED,b.directory_name  from dba_objects a,dba_directories b where a.object_type like 'DIR% and a.object_name=b.directory_name';

