I have a rather large Oracle environment which I am trying to pull data from. I have a Microsoft SQL background, but I am not familiar with Oracle. To look for this data, I am using Oracle SQL Developer.
I am noticing many DBF files which contain data. There is one which I believe has the data that I am looking for. I am making this assumption based on the name of the file. When I look at the Oracle environment using Oracle SQL Developer, there are hundreds of tables which I am having to look through. Is there a way in Oracle SQL Developer to have it only show tables a specific DBF files?
Any input or suggestions would be greatly appreciated.
Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.
This post first appeared at Oracleinaction (http://oracleinaction.com/undo-and-redo-in-oracle/)by Anju Garg (Myself).
I will demonstrate that undo for DML’s is stored both in undo tablespace and online redo logs. Then, we will analyze the reaso…
As technology users and professionals, we’re always learning. Our universal interest in advancing our knowledge of the trade is unmatched by most industries. It’s a curiosity that makes sense, given the climate of change. Within that, there lies a…