Re: initrans, maxtrans, actual number of transaction entries

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

Frank Hubeny wrote in message <383ACD51.615D569E_at_ntsource.com>...
>The alter database dump command sounds interesting but I have not been able
>to get it to work.
>
>I have also searched the SQL Reference 8.1.5 without finding anything
>relevant that has the word "dump" in it.
>
>I get the following errors in trying to use the command:
>
>SQL> alter database dump datafile 'c:\oracle\oradata\mydb\users01.dbf'
>block 100;
>alter database dump datafile 'c:\oracle\oradata\mydb\users01.dbf' block 100
>
> *
>ERROR at line 1:
>ORA-01916: keyword ONLINE, OFFLINE, RESIZE, AUTOEXTEND or END/DROP expected
>
>Now trying it with "data file":
>
>SQL> alter database dump data file 'c:\oracle\oradata\mydb\users01.dbf'
>block 100;
>alter database dump data file 'c:\oracle\oradata\mydb\users01.dbf' block
>100
> *
>ERROR at line 1:
>ORA-02231: missing or invalid option to ALTER DATABASE
>
>Now trying it with the file_id:
>
>SQL> alter database dump datafile 3 block 100;
>alter database dump datafile 3 block 100
> *
>ERROR at line 1:
>ORA-01916: keyword ONLINE, OFFLINE, RESIZE, AUTOEXTEND or END/DROP expected
Received on Tue Nov 23 1999 - 11:20:50 CST