Datapump backup steps?



Datapump backup steps?..

Answer / kittu_chintu2005

Create a file structure @ oracle level by issuing the statement "create directory dpump_dir1 as '/disk01/oradata/mine/dpump'';" "grant read, write to user1, user2;"
@ OS "level mkdir -p /disk01/oradata/mine/dpump"

And then issue the statement @ OS level "expdp directory=dpump_dir1 dumpfile=xxxxx.dmp"

Is This Answer Correct ?    3 Yes 0 No

Post New Answer

More DB Administration Interview Questions

orra 1555 what is this error,why it is occur?

2 Answers   Mphasis,


What view would you use to look at the size of a data file?

3 Answers  


How do you open a cluster administrator? : sql server DBA

0 Answers  


Explain the use of table functions.

1 Answers  


how can a session indicate its interest in receiving alerts?

0 Answers   Oracle,


Explain about your sql server dba experience? : sql server DBA

0 Answers  


Where would you look for errors from the database engine?

0 Answers   IBM,


Database crashes. Corruption is found scattered among the file system neither of your doing nor of Oracle's. What database recovery options are available? Database is in archive log mode.

0 Answers   Infosys,


I want to export only structure of the table from oracle database. In that table to used the some partition. To export the table in general way then compilation error was occured i.e-EXP-00003: no storage definition found for segment(11, 2771). Please tell me the correct export command parameter to export the partitioned table. Thanks in Advance..........

1 Answers  


What is the difference between clustered and non-clustered index? : sql server DBA

0 Answers  


what is rebuild index??

2 Answers   IBM, Sapient,


. I have my backup RMAN script called "backup_rman.sh". I am on the target database. My catalog username/password is rman/rman. My catalog db is called rman. How would you run this shell script from the o/s such that it would run as a background process?

0 Answers  


Categories