automating database refreshes
Hi all, I've been given a task to write a script automatically take an full export file from a production server and put in a test server. From there do an import to the database. I've never done this before, does anyone have any ideas or suggestions? Thanks
create a test database and create all tablespace that were existed on Production database and run a full import
thanks mike, actually I tried to write a unix shell script would do all of these, basically automate the whole process. you have any ideas?
write a shell script:
1. set sid
2. to take an exp with logs
3.change the oracle_sid
4. imp with logs
5.send email that imp was done to dba.
"High Salaries = Happiness = Project Success."
Click Here to Expand Forum to Full Width