Re: newbie: Pl/SQL - loop - hotbackup

What you're doing may not be such a good idea, however. Generally it's recommended to put the first tablespace into backup mode, back it up, then alter ts end backup, then onto the next tablespace. If there's any activity in the database, it's not a good idea to put all the tablespaces into backup mode at once.
For some good stuff on backups, take a look at Howard Roger's site; http://www.hjrdba.com

HTH,
Paul

"Vi." <viper_at_gmx.fr> wrote in message
news:2ea00f5e.0204051026.3041cea0_at_posting.google.com...
> Thank you for your help.
>
> Jean-Noel.
>
>
> "Roman Mirzaitov" <rmirzaitov_at_kt.kg> wrote in message
news:<a8j4bi$sthh5$1_at_ID-127142.news.dfncis.de>...
> > Hi,
> >
> > looking carefully at your code I guess that you miss one | sign right
after
> > ...TABLESPACE '| ... statement.
> > Change like that: TABLESPACE '|| ... This is the first mistake.
> > And also I suggest to replace ||tablespacename|| expression with
> > ||tablespacename.tablespace_name|| one.
> >
> > Regards,
> >
> > --
> > Roman Mirzaitov
> > Brainbench MVP for Oracle Administration
> > www.brainbench.com
> >
> >
Received on Sat Apr 06 2002 - 10:02:55 CST