i have a question. An application works as having an oracle schema e.g. "abcd" and it has all objects inside tablespace "abcd". Now normal procedure to backup is to take export of that schema obviously which takes some time as data is growing. An in case we have to recover schema by importing from that export file it takes many hours.
is there any quick solution to this problem?
can only tablespace backup /restore can help in this scenario?
Quick question: you are using datapump (expdp/impdp), right? If your version has them, they are much faster than exp/imp, even with direct=Y. Migrate to datapump if you've not already done so and you'll
Learn about Hyper-V features that increase functionality and usability of Microsoft Windows Server 2016. Also, throughout this eBook, you’ll find some basic PowerShell examples that will help you leverage the scripts in your environments!
Entering a date in Microsoft Access can be tricky. A typo can cause month and day to be shuffled, entering the day only causes an error, as does entering, say, day 31 in June. This article shows how an inputmask supported by code can help the user a…
When table data gets too large to manage or queries take too long to execute the solution is often to buy bigger hardware or assign more CPUs and memory resources to the machine to solve the problem. However, the best, cheapest and most effective so…