you have to set the following parameters:
compatible=9.2.0.0.0 (or higher)
undo_tablespace=your_undo_table_space
undo_management=AUTO
AND: in future please use another subject (as "hi") for your posting ... ;-)
hth
Rüdiger J. Schulz
sosys-berlin.de
Mayank Jain schrieb:
>This is the error whilte intalling can any one help me please
>
>
>
>ERROR at line 1:
>
>ORA-30019: Illegal rollback Segment operation in Automatic Undo mode
>
>
>
>
>
>Thanks & Regards :-)
>
>Mayank Jain
>
>(Database Administrator Trainee)
>
>
>
>
Oracle LazyDBA home page