Hi !
The simple thing is you can edit the datablocks using
BBED editor. It is shipped with Oracle and You need a
password to use that utility. You can browse and edit
the data blocks.
$BBED will give the required details. BUT IT IS
DANGEROUS
--- novicedba <[EMAIL PROTECTED]> wr
It apparently is only on NT, and unless you have the password,
which is known only to Oracle Support Personnel, you can't
use it.
http://www.ixora.com.au/q+a/0101/23224038.htm
Jared
On Thursday 31 May 2001 12:10, K Gopalakrishnan wrote:
> Hi !
>
>
> The simple thing is you can edit the databl
Do a
"dd" on unix and change the contents of any particular
block.
-Original Message-From: novicedba
[mailto:[EMAIL PROTECTED]]Sent: Thursday, May 31, 2001 2:16
PMTo: Multiple recipients of list ORACLE-LSubject: How
do I corrupt a block
hi,
This may sound funny. I wa
You can write a little perl script to write over the block. Just open the
datafile, sysseek to (block_number)*(block_size), then
syswrite(chr(0),block_size). Strangely though, the naive approach of
overwriting a block entirely with nulls results in a block which is not
detectable with dbms_repai
unfortunately i am on NT
I can not use BBED because i don't know the password
is there any other way
- Original Message -
To: "'novicedba'" <[EMAIL PROTECTED]>
Sent: Thursday, May 31, 2001 11:40 PM
> I do not recommend this, but since you are bent on doing this:
> (Hope you are on Unix)
There are un-documented init.ora parameters that can be used to corrupt such
things as the rollback segments and tablespaces. Maybe there is one that
can be used to corrupt a specific block of a datafile as well.
Contact ORacle Support and see if they have any of these. They would be
undocum
talk to your lead duhveloper..they are usally good at that ;-)
Sunil Nookala
Dell Corp
Austin, TX
-Original Message-
Sent: Thursday, May 31, 2001 5:06 PM
To: Multiple recipients of list ORACLE-L
unfortunately i am on NT
I can not use BBED because i don't know the password
is there any
BBED isn't an option unless you can talk Oracle support into taking part in
your experiment - unlikely. (Or perhaps find an appropriate WaReZ site!
(8-o) Any hex editor will do if you aren't particular about exactly what
you change in the block. If you know Oracle block internals you can get a
Jared, BBED is available on UNIX, you just have to make
it with the make command.
cd $ORACLE_HOME/rdbms/lib
make -f ins_rdbms.mk $ORACLE_HOME/rdbms/lib/bbed
The bbed command can allow you to soft corrupt a block
and you can use the "dd" command to hard corrupt the
block. The bbed command doe
