Oracle Database Discussions

Hi ,

ORACLE 11g
Solaris 10
ASM

Undo tablespace unable to grow beyond 31gb. it gives below error message while importing dump file which contain data of 45gb.

ORA-30036: unable to extend segment by 8 in undo tablespace 'UNDOTBS1'

CREATE UNDO TABLESPACE undotbs_02 DATAFILE '+DATA/lims/hdb/undotbs02.dbf' SIZE 100M REUSE AUTOEXTEND ON NEXT 10M MAXSIZE UNLIMITED;

SQL> show parameter undo

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
undo_management                      string      AUTO
undo_retention                       integer     900
undo_tablespace                      string      UNDOTBS_02


                                                             %
Tablespace Name        KBytes         Used         Free   Used
---------------- ------------ ------------ ------------ ------
*UNDOTBS_02        33,546,240   33,546,240            0  100.0
                 ------------ ------------ ------------
sum                33,546,240   33,546,240            0

with similar configuration machine it works fine with same dump file. is there anything we are missing ?

regards
sachin