Taking full backup with Toad
Can you please tell me how to take a backup of a database? I am using Toad, but Toad has options to take each component (like tablespace, table data) backup separately while I need the backup of the whole database. Can you send me the script, if we need to use one?
Can you please tell me how to take a backup of a database? I am using Toad, but Toad has options to take each component (like tablespace, table data) backup separately while I need the backup of the whole database. Can you send me the script, if we need to use one?
Backups are not a task to be taken lightly. I highly recommend reading the backup and recovery documentation.
Today's Oracle DBA should highly consider using RMAN for a backup and recovery strategy. Read the RMAN documentation.