Please send your Questions & Answers or Feedback to "dvmadhavreddy@javabook.org"

Please send your Questions & Answers or Feedback to "mohan@javabook.org"

Data pump exporting : User level backup

oracle> expdp dumpfile=user.dmp logfile=user.log schemas=scott directory=dp

                username : / as sysdba

SQL> select count(*) from tab;

                Check for the tables before starting the job and after ending the job.

No comments:

Post a Comment

Related Posts Plugin for WordPress, Blogger...

Flag Counter