Spooling output to another server
Hello good people i was wondering if anyone could help.
I'm a junior tester helping with some Disaster Recovery stuff, and i have to test weather data gets during the transfer to a second system when the plug is pulled on a primary system.
I am doing this by spooling the whole database into text files as a base line, then spooling again after the plug has been pulled then comparing the two sets of files to see if any data has been lost.
I was windering if there is a way to spool output to another server with larger diskspace as i need 200gig worth of diskpace and that simply isnt availabel on the database server.
so to sum up, is there anyway to spool output using sqlplus to another machine's directory??
All help is greatly appreciated, thank you.