to post messages and comments.

i have the same error " ORA-30012: undo tablespace "

from u r advice i have changed the pfile parameter for undo to manual -"undo_management=MANUAL".

but i need a alternative solution for this from the beginning,, (while Creating the database)?

And i want to know why this is happening (reason)?