Home » Developer & Programmer » Designer » Oracle 9i Designer - Journal Tables
Oracle 9i Designer - Journal Tables [message #84018] Sun, 18 January 2004 22:56
Zaire
Messages: 36
Registered: October 2002
Member
Hi all,

In designer 9i you can auto generate journal tables to track inserts, updates and deletes, which writes relevant records that were ins, upd, or del to the journal tables. The journal table name defaults to table_name_JN, where table_name is the table for which you want to generate the journal table.

Is there anyway to name the journal tables as you wish, instead of using the auto generated name of the form table_name_JN?

 

Thanx
Previous Topic: 'partial' foreign keys ??
Next Topic: Actual Space taken by Varchar2
Goto Forum:
  


Current Time: Thu Nov 21 13:36:16 CST 2024