help me

[jomon_s]

hi all.


when I execute this queery


SQL> select dbms_metadata.get_ddl('TABLE','EMP') from dual;


in oracle 9i database I get the following errors


ERROR:
ORA-25153: Temporary Tablespace is Empty
ORA-06512: at "SYS.DBMS_LOB", line 395
ORA-06512: at "SYS.DBMS_METADATA", line 1204
ORA-06512: at line 1


Can any one help me in solving this.



Joe

[Calvin_Qiu]

ORA-25153 Temporary Tablespace is Empty
Cause: An attempt was made to use space in a temporary tablespace with no
files.
Action: Add files to the tablespace using ADD TEMPFILE command.