The solution, however, is simple enough. All you need to do is use the Data Pump Restart Capability:
1) In the IMPDP window, click CTRL-C to stop the job.
2) In the command line type:
Import> stop_job=immediate
3) Use SQLPlus to make the required changes to the table space. You can:
a) Add DataFile ALTER TABLESPACE <tablespace name> ADD DATAFILE ‘<path to file name and file name>’ SIZE <integer>M;
b) Resize the Datafile:
ALTER DATABASE DATAFILE ‘< path to file name and file name >’ RESIZE <integer>M;
c) Enable autoextend:
ALTER DATABASE DATAFILE ‘< path to file name and file name >’ AUTOEXTEND ON MAXSIZE UNLIMITED;
4) Attach the Job.
>impdp system/manager attach=Job_Name
If you did not provide a specific job name when you first ran the IMPDP, Oracle will assign a default name for it. In order to find the System assigned name for the IMPDP job you can run the following query:
SELECT * FROM DBA_DATAPUMP_JOBS;
The result will probably be something like SYS_IMPORT_FULL_number.
5) Restart the job
Import> start_job
6) You can check the status of the job by simply typing STATUS in the utility command prompt.
Import> status
1) In the IMPDP window, click CTRL-C to stop the job.
2) In the command line type:
Import> stop_job=immediate
3) Use SQLPlus to make the required changes to the table space. You can:
a) Add DataFile ALTER TABLESPACE <tablespace name> ADD DATAFILE ‘<path to file name and file name>’ SIZE <integer>M;
b) Resize the Datafile:
ALTER DATABASE DATAFILE ‘< path to file name and file name >’ RESIZE <integer>M;
c) Enable autoextend:
ALTER DATABASE DATAFILE ‘< path to file name and file name >’ AUTOEXTEND ON MAXSIZE UNLIMITED;
4) Attach the Job.
>impdp system/manager attach=Job_Name
If you did not provide a specific job name when you first ran the IMPDP, Oracle will assign a default name for it. In order to find the System assigned name for the IMPDP job you can run the following query:
SELECT * FROM DBA_DATAPUMP_JOBS;
The result will probably be something like SYS_IMPORT_FULL_number.
5) Restart the job
Import> start_job
6) You can check the status of the job by simply typing STATUS in the utility command prompt.
Import> status
No comments:
Post a Comment