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 implement fine-grained auditing?
Query processing is slow(eg select query)how will u solve that
what are the differences of where and if in SAS?
what is the role of dip user in our database?
Where do you find the default index fill factor and how to change it? : sql server DBA
Typically, where is the conventional directory structure chosen for Oracle binaries to reside?
What is fill factor? : sql server DBA
How many files can a database contain in sql server?how many types of data files exists in sql server? How many of those files can exist for a single database? : sql server DBA
currently iam working in mnc as a oracleappsdba,please send the EXPERIENCE RESUME those who r worked as a oracle apps dba
internal architecture
What are the commands you'd issue to show the explain plan for "select * from dual"?
What purpose does the model database server? : sql server DBA
What are the operating modes in which database mirroring runs? : sql server DBA
what is the diffrence between core dba and apps dba?
