how to backup oracle 10g

Question

hi

how i can backup oracle 10g like backup and restore in sql server ?

i want to backup tables and data

thank's in advance

Answer 1

The typical term for this is 'migrate' not 'backup'. You'll then find results in your favorite search engine to tools like: SQL Server Migration Assistant for Oracle

Answer 2

If you only want table structures and data (no code), you can use SQL Server Integration Services (SSIS) package for this.

Read up here on the various methods and their associated speed

http://sqlcat.com/technicalnotes/archive/2008/08/09/moving-large-amounts-of-data-between-oracle-and-sql-server-findings-and-observations.aspx

Answer 3

Oracle has a comprehensive backup and recovery suite which is formally called Recovery Manager but is universally known as RMAN. Find out more.