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 |
orra 1555 what is this error,why it is occur?
What view would you use to look at the size of a data file?
How do you open a cluster administrator? : sql server DBA
Explain the use of table functions.
how can a session indicate its interest in receiving alerts?
Explain about your sql server dba experience? : sql server DBA
Where would you look for errors from the database engine?
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.
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..........
What is the difference between clustered and non-clustered index? : sql server DBA
what is rebuild index??
. 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?