Purpose
Changes the state of all tables in the specified database from Active to Read-Only.
Syntax
DATABASE FREEZE {<database> [ON tdpid[,tdpid]]} [REASON 'reason'];
Parameters
- database
- Name of database holding tables currently in Unity Data Dictionary.
- tdpid
- Unique identifier (TDPID) of a Teradata Database system.
- reason
- Description of why objects on the database need to change.
Usage Considerations
If a system is not specified when running this command, it sets all tables in the database to Read-only on ALL systems, which is not usually correct. Specify a system to make the tables Read-Only on one system.