Backup in Oracle10g

[arunbalait]

Hi all

Are there any options to take backup our database in Oracle 10g?

I want to take backup my database and then have to restore as like SQL Server.

Every time am creating tables and inserting values. It troubles me.

Plz give me some suggestions to resolve this.

Thanx...

[debasisdas]

You need to use the utility tools IMPORT / EXPORT for the purpose.

[arunbalait]

You need to use the utility tools IMPORT / EXPORT for the purpose.

Is it comes along with Oracle intallation? I found nowhere such option for Import/Export

Thanx

[amitpatel66]

Is it comes along with Oracle intallation? I found nowhere such option for Import/Export

Thanx

To make use of IMPORT and EXPORT utility, go to:

Start ->> Run, type cmd

in command prompt,
you can use import and export utility.
For more details, check here