Could someone please post the syntax for
ALTER SYSTEM CHECK DATAFILES.
How can I specify individual datafile in this ALTER SYSTEM CHECK DATAFILES.
I have 10 datafiles and I wana run this for all 10 datafiles one by one like:
ALTER SYSTEM CHECK DATAFILES '/u01/oradata/hr/hr_user01.dbf';
What is the correct syntax.
All the answers are appreciated.
Thanks,