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

Answers were Sorted based on User's Feedback



How to make a Data Backup in oracle ? What is the procedure for creating the dump files in oracle..

Answer / 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

How to make a Data Backup in oracle ? What is the procedure for creating the dump files in oracle..

Answer / divyadeepa

>exp ddk/log@orcl file={file location path}

Is This Answer Correct ?    4 Yes 1 No

How to make a Data Backup in oracle ? What is the procedure for creating the dump files in oracle..

Answer / ace dba

A dump is _NOT_ a backup. You cannot roll forward to a
point in time after the dump was taken. The dump is for
moving data from one environment to another, and etc. Using
dump for backup _WILL_ result in data loss.

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Oracle General Interview Questions

What is oracle open database communication (odbc)?

0 Answers  


What is a proxy class?

0 Answers  


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

3 Answers   Satyam,


What are temporal data types in oracle?

0 Answers  


How to create a server parameter file?

0 Answers  






Hi Masters, in Oracle Applications 11i, we hace 2 functions using the same form, i need to create 1 personalization, but that code must afect only one function.... how can i do that?

0 Answers  


write a sql query following source looking like below column1 column2 101,102,103 abc,def,ghi 1001,1002,1003 a,b,c i want the output column1 column1 101 abc 102 def 103 ghi 1001 a 1002 b 1003 c

1 Answers   KPIT,


How to add another datafile to a tablespace?

0 Answers  


How do I connect to oracle database?

0 Answers  


What is concurrency in oracle?

0 Answers  


How to call a stored procedure inside a trigger? Give an example.

1 Answers   Exilant,


What are the parameters that we can pass through a stored procedure?

0 Answers  


Categories
  • Oracle General Interview Questions Oracle General (1789)
  • Oracle DBA (Database Administration) Interview Questions Oracle DBA (Database Administration) (261)
  • Oracle Call Interface (OCI) Interview Questions Oracle Call Interface (OCI) (10)
  • Oracle Architecture Interview Questions Oracle Architecture (90)
  • Oracle Security Interview Questions Oracle Security (38)
  • Oracle Forms Reports Interview Questions Oracle Forms Reports (510)
  • Oracle Data Integrator (ODI) Interview Questions Oracle Data Integrator (ODI) (120)
  • Oracle ETL Interview Questions Oracle ETL (15)
  • Oracle RAC Interview Questions Oracle RAC (93)
  • Oracle D2K Interview Questions Oracle D2K (72)
  • Oracle AllOther Interview Questions Oracle AllOther (241)