select volume_name from contents where file_name like (???%)

file_name is the client's name for the file

you possible could replace file_name with filespace_name since the oracle db 
probably would be in it's own file space

>>> bill.jolley AT EDS DOT COM 05/03/01 11:45pm >>>
I am looking for a select statement to identify tape volumes used during an
oracle db backup
for a specific date (04/20/01).  Can anyone help me?

Thanks


William M. Jolley
EDS
9014 Research Drive
Charlotte, NC  28226

Tel:704-548-5524
pag:877-471-5029

email:bill.jolley AT eds DOT com