Give two methods you could use to determine what DDL
changes have been made.
Answers were Sorted based on User's Feedback
Answer / Ram Subhash Maurya
One method is to query the DBA_LOGSTAS table, which stores information about all database transactions. You can filter for DDL operations and sort by timestamp to see the changes in chronological order. Another method is to examine the control files and datafiles using operating system commands or Oracle utilities like SQL*Plus.
| Is This Answer Correct ? | 0 Yes | 0 No |
what are the advantages of Oracle over other databases..? please give me reply...
Can we get the deleted Record again if the delete transaction has been committed.
Can we modify approve purchase order?if yes what is navigation?
What is the difference between conversions and interfaces? : oracle accounts receivable
What background process refreshes materialized views?
Differentiate between unidentified receipt, unapplied receipts and on account receipts? : oracle accounts receivable
Explain the difference between a data block, an extent and a segment.
What is autocashrule set? : oracle accounts receivable
how can we add a field to the oracle standard forms through Form Persanlization or custom.pll
how can it possibble to see the report output in excel sheet in oracle applications
Can you explain how to adjust the amount of advance already received against an invoice? : oracle accounts receivable
which one is currently in used software cmpanies.