I have a few PeopleSoft databases that each contain 20,000+ tables in them. Occasionally we do something in a development environment where we want to restore tables from the last back up. With the size of the database, we can occasionally run into space issues, not to mention the fun of scrolling through a GUI to select tables out of a list that long.
Is there any way to script the Object Level Receovery?
The one or two times I tried the wizard, I ended up backing out and just finding somewhere to restore the entire database. I am hoping that I am just missing something.