oracle hot backup script

[steven chang_1]

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 chang_1]

here is the tsinfo.sql

[Hari Kumar · Accepted solution]

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.

[steven chang_1]

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