Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

ORA-25153: Temporary Tablespace is Empty has been detected ??

28348Nov 10 2008 — edited Nov 10 2008

After recover database, I got the following error message:

ORA-25153: Temporary Tablespace is Empty has been detected in FND_GLOBAL.INITIALIZE

I try to resolve this problem and issue the following command:

SQL> create temporary tablespace temp tempfile '/u01/oracle/uatdata/temp02.dbf' size 500M
2 extent management local;
create temporary tablespace temp tempfile '/u01/oracle/uatdata/temp02.dbf' size 500M
*
ERROR at line 1:
ORA-01543: tablespace 'TEMP' already exists

Please advice,
Amy

Locked Post

New comments cannot be posted to this locked post.

Locked on Dec 8 2008

Added on Nov 10 2008

#general-database-discussions

2 comments

1,453 views