If no trnasactions are using that temp tbs, you cna drop and recreate it.
Sanjay G. Oracle Certified Professional 8i, 9i. "The degree of normality in a database is inversely proportional to that of its DBA"
Forum Rules
Reply With Quote