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
who owns the operating system files created by the utl_file package?
What are the commands you'd issue to show the explain plan for "select * from dual"?
currently iam working in mnc as a oracleappsdba,please send the EXPERIENCE RESUME those who r worked as a oracle apps dba
What is the default fill factor value? : sql server DBA
What are the differences in clustering in sql server 2005 and 2008 or 2008 r2? : sql server DBA
Where do you find the default index fill factor and how to change it? : sql server DBA
How do you trace the traffic hitting a sql server? : sql server DBA
What authentication modes does sql server support? : sql server DBA
Other than making use of the statspack utility, what would you check when you are monitoring or running a health check on an Oracle 8i or 9i database?
how can you enable flashback feature?
what is ora 24313?what is the procedure to exclude that error?
Why would you call update statistics? : sql server DBA
List out some of the requirements to setup a sql server failover cluster.? : sql server DBA
what is grd?
how can you create a user-defined lock?