Datafile verify script

From: <jdanton1_at_yahoo.com>
Date: Tue, 23 Feb 1999 20:32:36 GMT
Message-ID: <7av394$vkj$1@nnrp1.dejanews.com>

To all:

I run the following script to very datafile status:

select 'dbv file='||file_name, 'logfile='||tablespace_name||'.'||'log', 'blocksize=8192' from sys.dba_data_files order by file_name

the format comes back as the following:

dbv file=/orad03_B/b91prd03/amost001.ds001.dbf            logfile=AMOST001.log
                 blocksize=8192

What I would like to do is produce the logfile name as amost001.ds001.dbf.log, without hard coding it as the file name.

Does anyone know if by using some sort of substring function if I can accomplish this?

Thanks,

Joey D'Antoni

-----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own Received on Tue Feb 23 1999 - 14:32:36 CST