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