This clause is required if the CREATE TABLE statement specifies some level of journaling, but a default journal table was not defined for the database in which the new table is being created.
If you specify permanent journaling for this table, but do not specify a journal table with this clause, then you must define a default permanent journal table for the containing database.
If a default permanent journal table was defined for the database, then this clause can be used to override the default.
You cannot add or modify journal options for a NoPI table or for a column-partitioned table.
Journal options are not supported for tables with row sizes greater than 64KB.
- table_name
- The name of the permanent journal table to be used for the data table being created.
- database_name
- If you specify a database name, then that name must exist and table_name must have been defined as its default permanent journal name.
- user_name
- If you specify a user name, then that name must exist and table_name must have been defined as its default permanent journal name.