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 can you generate profile of pl/sql applications to identify performance bottlenecks?
how can you connect from 10g user to 11g user??
how can you get actual data change values from previous transactions in oracle?
Why would you use sql agent? : sql server DBA
What are the commands used in dcl? : sql server DBA
Query processing is slow(eg select query)how will u solve that
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
What are the different ways you can create databases in sql server? : sql server DBA
what is asm?
which background process invoke at the time of upgradation tell me???
how can you find out if a table can be redefined?
Assuming today is Monday, how would you use the DBMS_JOB package to schedule the execution of a given procedure owned by SCOTT to start Wednesday at 9AM and to run subsequently every other day at 2AM.
Due to some maintenance being done, the sql server on a failover cluster needs to be brought down. How do you bring the sql server down? : sql server DBA
When setting replication, can you have distributor on sql server 2005, publisher on sql server 2008? : sql server DBA
In what script is "snap$" created? In what script is the "scott/tiger" schema created?