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