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 : Full database backup

oracle> expdp dumpfile=fulldb.dmp logfile=fulldb.log full=y directory=dp job_name=fulldatabase

                username : / as sysdba

SQL> select count(*) from tab;

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

 

                stopping a job :

                press Ctrl C to stop a job.

                export> stop_job=immediate

                SQL> select * from dba_datapump_jobs;

                SQL> select * from tab;

 

                attaching a job(reinitiating a job):

                scott> conn / as sysdba

                SQL> select * from dba_datapump_jobs;

                oracle> expdp attach=fulldatabase

                                username : / as sysdba

                export> continue_client

                SQL> select * from dba_datapump_jobs;

No comments:

Post a Comment

Related Posts Plugin for WordPress, Blogger...

Flag Counter