Re: initrans, maxtrans, actual number of transaction entries

Thanks! Both commands worked.

What surprises me is that neither of these commands is in the SQL Reference 8.1.5 manual. (A67779-01, February 1999) I checked again to make sure I didn't miss it last time. And I even sent infodev_at_us.oracle.com a message asking where the commands were documented.

Did you learn these from experience, an old SQL Reference manual or is there another source for Oracle SQL?

Frank Hubeny

Jonathan Lewis wrote:

> Sorry, that should have been
> alter SYSTEM dump datafile NNNN block MMMM;
>
> and the response is
> system altered
>
> It is by file number and block number, and the file/block
> you want will be header_file, header_block from dba_segments.
>
> There is an alternative syntax to dump consecutive blocks:
> alter system dump data file NNN block min PPPP block max QQQQ;
>
> --
>
> Jonathan Lewis
> Yet another Oracle-related web site: http://www.jlcomp.demon.co.uk
>
Received on Tue Nov 23 1999 - 14:57:02 CST