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
How to craeate the New Database Schema in Oracle and mysql? Please tell me with Example?
how can you generate profile of pl/sql applications to identify performance bottlenecks?
Why would you call update statistics? : sql server DBA
How do you open a cluster administrator? : sql server DBA
What are the high-availability solutions in sql server and differentiate them briefly? : sql server DBA
What is the cache hit ratio, what impact does it have on performance of an Oracle database and what is involved in tuning it?
You have 4 instances running on the same UNIX box. How can you determine which shared memory and semaphores are associated with which instance?
How can you control the amount of free space in your index pages? : sql server DBA
how does an oracle clusterware manage crs resources?
Where would you look for errors from the database engine?
Illustrate how to determine the amount of physical CPUs a Unix Box possesses (LINUX and/or Solaris).
how can you enable flashback feature?
what are the differences of where and if in SAS?
how can you implement fine-grained auditing?
What is transparent data encryption? : sql server DBA
