Re: How to create an UNRECOVERABLE empty table??

Why are you so adamant about a create table unrecoverable without any rows being create at create time as in the case with the create <tablename> as select .... If the latter does not apply to your situation then the create table won't have an impact on performance....it's a simple DDL.

However, If you really need to do it.. and you have an existing table with the same structure you may want to try:

create table <tablename> unrecoverable as select * from <other_table> where rownum <1;

NOTE: this will not bring over any indexes... Cheers,
Robert Prendin

Robbo7 <robbo7_at_ozemail.com.au> wrote:

>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
>

Robert Prendin
RP Data Solutions Inc.
Specializing in ORACLE DBA Support Services Received on Fri Jan 15 1999 - 08:45:01 CST