Re: Disabling rollback. Is it possible?

On our project we have some very busy tables that we store in the Oracle 7.1.4 database. These tables contain objects that do not require the recovery features of the database, but the database is nice because it simplifies our interface. In other words, we use the database to store all our objects both percistent and non-percistent.

I saw a mention on this thread to creating a table with NO RECOVERY.

Is that possible on Oracle 7.1.4 or do I need to wait for 7.2 and use Create table as Select?

>Andrew Esplan
 

>Chuck, it's great to find someone else who doesn't want to use all of
>Oracle's wonderful recovery features, these are often not required in
>a Data Warehouse environment. I don't know which version of Oracle
>you are using but you should have a look at V7.2. It contains a
>feature which allows you to disable logging for nominated tables, I
>think it goes something like CREATE TABLE...NO RECOVERY. It will
>certainly work in a CREATE TABLE AS SELECT scenario, I am not sure if
>it extends to all operations on the table (i.e. LOADER, UPDATE,
>DELETE, INSERT etc). I am still waiting for Oracle to release 7.2 for
>the Pyramid DC/OSX platform, I can't wait because it includes many
>performance improvements for Data Warehousing.

Thanks

Dave Received on Wed Aug 23 1995 - 00:00:00 CEST