How to create an UNRECOVERABLE empty table??

Hi,

I am using Oracle 7 and creating a temporary table in SQL that I wish to be UNRECOVERABLE for performance reasons. When I create the table I do not wish to add any records then but rather I populate the table in PL/SQL later as it is faster. However, it seems that one can't specify the UNRECOVERABLE option on CREATE TABLE unless it is qualified with an AS subquery. As I am not adding any records when the table is created I don't have an AS subquery. Does anyone know a way of creating a dummy sub query so my empty table is UNRECOVERABLE or a better way of achieving what I want?

Robbo Received on Fri Jan 15 1999 - 04:23:53 CST