Oracle database backup for visual studio 2010.

Category: sql server manageability


chinnudhilip on Tue, 11 Dec 2012 09:05:13

I am building a windows application using Oracle 10g expressedition and vs2010 ultimate... but I need to make  the database backup as like MS SQL server 2005 or 2008. How to backup a <data.bak> in oracle or any other formats available.  


Sean Gallardy on Tue, 11 Dec 2012 13:00:27


You'll want to post this question in the Oracle forums as this is the SQL Server forums. AFAIK the only way to get a whole database backup like the SQL Server one is to shut down the oracle service and copy the files at the OS level. Oracle can do "hot backups" but that would be akin to our transaction log backups and not what you're looking for. You could also datapump the data and schema out but that's a database backup like MySQL.