Q
Problem solve Get help with specific problems with your technologies, process and projects.

Viewing log files on version 7.3.3 on OS/390

In Oracle for OS/390 ver. 7.3.3, how can I see the log files? The log files are VSAM files, but I'm not able to repro it to a ps file (showing the log files are held). Also suppose the database is in archive mode, how can I get the path where the log files are archived? Suppose somebody has changed a table, where can I get the details of it, like who has changed the table and when?

I don't know of anyway to see inside the redo log files until Oracle 8i and the implementation of Log Miner. Until that time, you'd have to implement your own version of tracking table changes using triggers to capture changes and writing them out to audit tables you create yourself.

For More Information


Dig Deeper on Oracle database design and architecture

Have a question for an expert?

Please add a title for your question

Get answers from a TechTarget expert on whatever's puzzling you.

You will be able to add details on the next page.

Start the conversation

Send me notifications when other members comment.

Please create a username to comment.

-ADS BY GOOGLE

SearchDataManagement

SearchBusinessAnalytics

SearchSAP

SearchSQLServer

TheServerSide.com

SearchDataCenter

SearchContentManagement

SearchHRSoftware

Close