Then he presses CTRL C to enter into interactive mode.
Then he will get the Export STOP_JOB=IMMEDIATEAre you sure you wish to stop this job ([y]/n): y The job is placed in a stopped state and exits the client.
Afterwards when your work has been finished you can continue the job from the same client, where you stopped the job, or you can restart the job from another client machine.
For Example, suppose a DBA starts a full database export by typing the following command at one client machine CLNT1 by typing the following command $ expdp scott/[email protected] FULL=y DIRECTORY=data_pump_dir DUMPFILE=LOGFILE=JOB_NAME=myfull Job After some time, the DBA wants to stop this job temporarily.
7782 CLARK MANAGER 7839 2572.50 10 7839 KING PRESIDENT 5500.00 10 7934 MILLER CLERK 7782 920.00 10 7566 JONES MANAGER 7839 3123.75 20 7499 ALLEN SALESMAN 7698 1600.00 300.00 30 7654 MARTIN SALESMAN 7698 1312.50 1400.00 30 7658 CHAN ANALYST 7566 3450.00 20 7654 MARTIN SALESMAN 7698 1312.50 1400.00 30 1. Create a table in Oracle, by any name, but should match columns specified in fixed length file.