cancel
Showing results for 
Search instead for 
Did you mean: 

oracle hot backup script

SOLVED
Go to solution
steven chang_1
Regular Advisor

oracle hot backup script

this script would call tsinfo.sql to generate
other sql statement to complete the backup
I would post the sql statement in another session.

steven
steven
3 REPLIES
steven chang_1
Regular Advisor

Re: oracle hot backup script

here is the tsinfo.sql
steven
Hari Kumar
Trusted Contributor
Solution

Re: oracle hot backup script

Once again Good work and extended Help.

addendum:
Think we dont need and cannot backup the TEMPORARY Tablespaces, so we can ommit the temporary tablespace and associated datafiles
in your script to make it better.
Information is Wealth ; Knowledge is Power
steven chang_1
Regular Advisor

Re: oracle hot backup script

hello hari:

To avoid backup temp tablespace, I need to writing PL/SQL staement to handle some situation. This could not be achieved by
just sql staement.I would study PL/SQL code
for future need.Thank you for your suggest.

steven
steven