Hi Geetha,

Your command is not correct.Try this command ;

select * from contents where volume_name='cdfd11'

MG




-----Original Message-----
From: ADSM: Dist Stor Manager [mailto:ADSM-L AT VM.MARIST DOT EDU] On Behalf Of
Geetha Thanu
Sent: Wednesday, February 25, 2004 2:08 AM
To: ADSM-L AT VM.MARIST DOT EDU
Subject: Re: restore data

Hi,

The command I gave was

select * from the contents volume_name=cdfd11

Is it correct?
Its not taking the command.

The access mode is readonly.
It is very well present in the autolib (library), but if i try to
restore
data from it is setting the mode as unaccessible.

Thanks
Geetha Thanu
Bioinformatics
CDFD,Hyderabad.









---------REPLY TO-------------
Date:Tue Feb 24 17:10:25 CST 2004
FROM: sujay dinakar  <sujay_dinakar AT YAHOO DOT COM>
To: ADSM-L AT VM.MARIST DOT EDU
Subject: Re: restore data
Hi


Check wether the database contains filenames for that
volume

select * from contents where volume_name=[your volume
name]

If it reports any files.

Check wether the use is locked or not


Change the Access mode to Readonly.

Dinakar




__________________________________
Do you Yahoo!?
Yahoo! Mail SpamGuard - Read only the mail you want.
http://antispam.yahoo.com/tools

-


This message and attachments are confidential and intended solely for the 
individual(s) stated in this
message.If you received this message although you are not the addressee you are 
responsible to keep the
message confidential .The sender has no responsibility for the accuracy or 
correctness of the
information in the message and its attachments.Our company shall have no 
liability for any changes
or late receiving,loss of integrity and confidentiality,viruses and any damages 
caused in
anyway to your computer system.

Bu mesaj ve ekleri mesajda gonderildigi belirtilen kisi/kisilere ozeldir ve 
gizlidir.Bu mesajin muhatabi
olmamaniza ragmen tarafiniza ulasmis olmasi halinde mesaj iceriginin gizliligi 
ve bu gizlilik yukumlulugune
uyulmasi zorunlulugu tarafiniz icin de soz konusudur.Mesaj ve eklerinde yer 
alan bilgilerin dogrulugu ve
guncelligi konusunda gonderenin ya da sirketimizin herhangi bir sorumlulugu 
bulunmamaktadir.Sirketimiz
mesajin ve bilgilerinin size degisiklige ugrayarak veya gec ulasmasindan, 
butunlugunun ve gizliliginin
korunamamasindan, virus icermesinden ve bilgisayar sisteminize verebilecegi 
herhangi bir zarardan
sorumlu tutulamaz.