×
Discuss about Archiving, Close of Business, Delivery Setup, Security Management System, Global Processing etc…
Detect modified rows in T24 oracle Tafj
- Mimi
- Topic Author
- Offline
- New Member
-
Less
More
- Posts: 2
- Thank you received: 0
1 year 1 month ago #24313
by Mimi
Detect modified rows in T24 oracle Tafj was created by Mimi
Hi guys,
Is there a way to track modified or new records in T24? I am writing an extraction program and I want to avoid the cost of full table extraction.
At the same time, doing a select with date time filter may even be more costly and in some cases it does not work.
I thought about using oracle ora_rowscn but our tables are not row dependency also ora_rowscn is not indexed so it takes a lot of time.
If there's a way to quickly identify only the amended and new records?
P.S: we are using T24, R20, oracle Tafj
Is there a way to track modified or new records in T24? I am writing an extraction program and I want to avoid the cost of full table extraction.
At the same time, doing a select with date time filter may even be more costly and in some cases it does not work.
I thought about using oracle ora_rowscn but our tables are not row dependency also ora_rowscn is not indexed so it takes a lot of time.
If there's a way to quickly identify only the amended and new records?
P.S: we are using T24, R20, oracle Tafj
Please Log in or Create an account to join the conversation.
- silvergem
-
- Offline
- Elite Member
-
- TAFC|R12/R13, TAFJ|R20
Less
More
- Posts: 267
- Thank you received: 21
1 year 3 weeks ago #24316
by silvergem
Replied by silvergem on topic Detect modified rows in T24 oracle Tafj
Check PROTOCOL and USER.ACTIVITY.DETAILS Application and filter all INPUT records.
Please Log in or Create an account to join the conversation.
- Mimi
- Topic Author
- Offline
- New Member
-
Less
More
- Posts: 2
- Thank you received: 0
1 year 3 weeks ago #24317
by Mimi
Replied by Mimi on topic Detect modified rows in T24 oracle Tafj
These tables can be deleted daily, and they only record changes made by users, not by the system. For example, changes to the #HIS table will not be saved in these tables.
Please Log in or Create an account to join the conversation.
Time to create page: 0.081 seconds