Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> how to take dump of file header?
Hello everyone,
I wanted to take the dump of the fileheader of one the files in my 'DATA' tablespace. The 'Backup and Recovery Guide' from Oracle Press says that the command 'ALTER SESSION SET EVENTS 'XXXXXXX';' has to be given but fails to mention the exact command. Also could anyone tell me as to how the decimal block address of a data file block is derived so that it can be used to take the dump of a data block using the appropriate ALTER SESSION SET EVENTS 'XXXXX' command.
Thanks in advance
suvamoy_at_hotmail.com
-------------------==== Posted via Deja News ====----------------------- http://www.dejanews.com/ Search, Read, Post to UsenetReceived on Thu Nov 20 1997 - 00:00:00 CST