exp username/password@databasename file=c:\filename.DMP full=N log=c:\file

How to make a Data Backup in oracle ? What is the procedure
for creating the dump files in oracle ( any version ) ?

Question Posted / s. senthil kumar

Answer Posted / s. senthil kumar

exp username/password@databasename file=c:\filename.DMP
full=N log=c:\filename.LOG

Is This Answer Correct ?

4 Yes

0 No

Please Help Members By Posting Answers For Below Questions

Can we use bind variables in oracle stored procedure?

899

What do you mean by a tablespace?

980

What are named parameters?

1035

Explain the use of owner option in exp command.

994

What is java oracle used for?

973

Can the query output be sorted by multiple columns in oracle?

936

What is the data pump export utility?

1023

What are the varoius components of physical database structure of oracle database?

946

How to start your 10g xe server from command line?

1001

How to connect to oracle using service name instead of sid?

964

how the Oracle Prepares the Execution Plan and how it chooses the Optimal one?

2290

How to write text literals in oracle?

1021

How do I manually uninstall oracle client?

1025

How to call a stored function with parameters?

972

what are steps for interface? where is exchange rate defined in which table?

2058