One way to do this, perhaps the most typical way, is through parsers that conform to the Simple API for XML (SAX) or the Document Object Model (DOM).
Both of these parsers are provided by Java API for XML Processing (JAXP).
Errors in file /test01/diag/rdbms/test 01/test 01/trace/ test 01_ora_12966.trc: ORA-19809: limit exceeded for recovery files ORA-19804: cannot reclaim 840186368 bytes disk space from 96636764160 limit ARCH: Error 19809 Creating archive log file to '/test 01/archive/test 01/archivelog/2011_06_10 /o1_mf_1_26619_%u_.arc' Errors in file / test01/diag/rdbms/ test01/ test01/trace/ test01_ora_12966.trc: ORA-16038: log 6 sequence# 26619 cannot be archived ORA-19809: limit exceeded for recovery files ORA-00312: online log 6 thread 1: '/ test01/oradata/ test01/redo06.log' USER (ospid: 12966): terminating the instance due to error 16038 Instance terminated by USER, pid = 12966 NAME TYPE VALUE ------------------------------------ ----------- ------------------------------ db_recovery_file_dest string /test01/archive db_recovery_file_dest_size big integer 91G Here 91G is allocated to db_recovery_file_dest which is at "/test01/archive" location.
If this location is full up to 91G, it will start giving above errors.
We get the next val, change the increment to be that (negative), select once to get it to zero and then reset the increment to 1. Just use the code I provided: column S new_val inc; select seq.nextval S from dual; alter sequence seq increment by -&inc minvalue 0; select seq.nextval S from dual; alter sequence seq increment by 1; select seq.nextval from dual; do that, as is, and it'll work as advertised. Thanks as always :) you'd have to goto prod, grab the sequence name and last_number from dba_sequences.
February 03, 2003 - am UTC just reset the value to be whatever "start with" value you want. test dababase has been populated by importing one month old dump of prod. we want to see the next values of sequences of test database at least equal to prod database's sequence next values. Then you can use the technique above in test to reset to zero, change the increment to last_number and select nextval (hence making the sequence "be at" last_number, then change the increment to 1 again and it'll be done.' INCREMENT BY '