how to backup oracle 10g

[E_Gold]

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

[Mycroft Holmes]

I thought the title was dumb - and even had this ready for you backup[^] but then I read the content. Correct me if I'm wrong but you seem to be asking if you can back up an Oracle database and restore it into SQL Server, assuming I have not completely misinterpreted you question. You CANNOT do that. There may be tools around that will allow you to generate a script from Oracle to create the equivalent database in SQL Server and then query the data across but backup is not going to work.