Answer Posted / 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 View All Answers
what are the differences of where and if in SAS?
Can you tell me about your experience with the administration of COTS system..? Also, how do you set up seed data..?
what is ora 24313?what is the procedure to exclude that error?
What authentication modes does sql server support? : sql server DBA
What are the different types of upgrades that can be performed in sql server? : sql server DBA
Why does Oracle not permit the use of PCTUSED with indexes?
what are the benefits of flashback feature?
What are the commands you'd issue to show the explain plan for "select * from dual"?
how can you find out if a table can be redefined?
What is the default fill factor value? : sql server DBA
What are the steps you will take to improve performance of a poor performing query?
what are the types of connection load-balancing?
What are the different authentication modes in sql server and how can you change authentication mode? : sql server DBA
how can you schedule a job in database?
What is the default port no on which sql server listens? : sql server DBA