Thursday, February 5, 2009

ORA-25153: Temporary Tablespace is Empty

When you recreate a control file or restore a controlfile from backup, you must recreate the tempfile in the temporary tablespace.

Alter temporary_tablespace add tempfile size xM reuse;

otherwise you will encounter the following error,

ORA-25153: Temporary Tablespace is Empty

Thanks

No comments:

Followers

Powered By Blogger
 

Oracle Database Administration. Copyright 2008 All Rights Reserved Revolution Two Church theme by Brian Gardner Converted into Blogger Template by Bloganol dot com