When I did a full export of my test db it took 10 hours. There is a 30 mil row table which took major chunk of the time.
Is it possible to run a full export and a table export at the same time? This table comes in the end of the sequence of full export. So it should not conflict with the full export. Once the table export is done, I want to drop the table.
One last question, when I did the full export I got this msg for a few tables but it exported the table rows though - "EXP-00079: Data in table "table_name" is protected. Conventional path may only be exporting partial table." Do I need to worry about it?
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.
How to Unravel a Tricky Query
If you browse through the Oracle zones or any of the other database-related zones you'll come across some complicated solutions and sometimes you'll just have to wonder how anyone came up with them. …
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…