Creating Unrecoverable Tables
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: Creating Unrecoverable Tables

  1. #1
    Join Date
    Jan 2002
    Posts
    65
    What are unrecoverable tables and What are the advantages/disadvantages of creating unrecoverable tables.
    Sabitabrata

  2. #2
    Join Date
    Apr 2001
    Location
    Czechia
    Posts
    712
    You didn't mention version, my is 8.1.7.

    You can create an unrecoverable table with deprecated clause UNRECOVERABLE or newer clause NOLOGGING while creating table.
    The creation of the table is not logged in redo logs so you can loose it if you don't make backup.
    Because of no redo log generation it can save space and time but it makes sense only if you create the table with CREATE TABLE AS SELECT ... statement or if you fill it with DIRECT-LOAD-INSERT: INSERT /*+ APPEND */ INTO nologging_table SELECT ....
    or if you use SQL*Loader.

    Other DML are fully logged.

    "No redo log generation" means almost no generation, some redo is always generated for dictionary changes.


    More you can find in the manual : http://otn.oracle.com/docs/products/....817/index.htm

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width