Quote Originally Posted by prk_dbaaspirant View Post
how to take hotbackup with out using pl/sql code ....
pl/sql code to take a hot backup?

You can either use the rman solution suggested by previous poster or do it the good-n-old way.

Put tablespaces in backup mode
Copy datafiles
Take tablespaces out of backup mode

Be sure your database is in archivelog mode and you are backing up your archivelogs.