Home | Previous Page | Next Page   Disk, Memory, and Process Management > Data Storage > Table Types for Dynamic Server >

RAW Tables

RAW tables are nonlogging permanent tables and are similar to tables in a nonlogging database. RAW tables use light appends, which add rows quickly to the end of each table fragments. Updates, inserts, and deletes in a RAW table are supported but not logged. RAW tables do not support indexes, referential constraints, or rollback. You can restore a RAW table from the last physical backup if it has not been updated since that backup. Fast recovery rolls back incomplete transactions on STANDARD tables but not on RAW tables. A RAW table has the same attributes whether stored in a logging or nonlogging database.

RAW tables are intended for the initial loading and validation of data. To load RAW tables, you can use any loading utility, including dbexport or the High-Performance Loader (HPL) in express mode. If an error or failure occurs while loading a RAW table, the resulting data is whatever was on the disk at the time of the failure.

Recommendation: Do not use RAW tables within a transaction. After you have loaded the data, use the ALTER TABLE statement to change the table to type STANDARD and perform a level-0 backup before you use the table in a transaction.

Warning:
Do not use Enterprise Replication on RAW or TEMP tables.
Home | [ Top of Page | Previous Page | Next Page | Contents | Index ]