Ora-01555

[liakat]

wht i say u "MR. GENIUS" i dont know how can ur a senior advisor!!!!!!!!!
I DO ALL IT ORACLE 9i...
SQL> show parameter undo_management

NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
undo_management string AUTO

SQL> show parameter undo_tablespace

NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
undo_tablespace string UNDOTBS1

SQL> show parameter undo_suppress_errors;

NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
undo_suppress_errors boolean FALSE


SQL> set transaction use rollback segment SYSSMU1$;
set transaction use rollback segment SYSSMU1$
*
ERROR at line 1:
ORA-30019: Illegal rollback Segment operation in Automatic Undo mode


SQL> alter session set undo_suppress_errors = true;

Session altered.

SQL> set transaction use rollback segment SYSSMU1$;

Transaction set.

go to www.asktom.oracle.com
also read artical from arup nanda who is dba of the year 2003.

RUBBISH ADVISOR.

stop writing rubbish, you can't do that in 9i with automatic undo!