当我们在oracle中导入数据时,报类型如下错误:

Import: Release 11.2.0.4.0 - Production on Thu Apr 30 14:37:29 2020

Copyright © 1982, 2011, Oracle and/or its affiliates. All rights reserved.

UDI-01017: operation generated ORACLE error 1017
ORA-01017: invalid username/password; logon denied

Username: nc65uat
Password:

Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
With the Partitioning, Oracle Label Security, OLAP, Data Mining,
Oracle Database Vault and Real Application Testing options
Master table “NC65UAT”.“SYS_IMPORT_SCHEMA_02” successfully loaded/unloaded
Starting “NC65UAT”.“SYS_IMPORT_SCHEMA_02”: nc65uat/******** dumpfile=nc65prod20200428.dmp directory=DATA_PUMP_DIR remap_schema=nc65prod:nc65uat schemas=nc65prod
Processing object type SCHEMA_EXPORT/USER
ORA-31684: Object type USER:“NC65UAT” already exists
Processing object type SCHEMA_EXPORT/SYSTEM_GRANT
Processing object type SCHEMA_EXPORT/ROLE_GRANT
Processing object type SCHEMA_EXPORT/DEFAULT_ROLE
Processing object type SCHEMA_EXPORT/PRE_SCHEMA/PROCACT_SCHEMA
Processing object type SCHEMA_EXPORT/TABLE/TABLE
Processing object type SCHEMA_EXPORT/TABLE/TABLE_DATA
ORA-39171: Job is experiencing a resumable wait.
ORA-01653: unable to extend table NC65UAT.SM_BUSILOG_DEFAULT by 128 in tablespace NNC_DATA01

此时该怎么办呢?
这时候我们应该先去查询磁盘空间是否使用完,使用命令 df -Th 查询,即
[root@fzoracle ~]# df -Th
Filesystem Type Size Used Avail Use% Mounted on
devtmpfs devtmpfs 16G 0 16G 0% /dev
tmpfs tmpfs 16G 0 16G 0% /dev/shm
tmpfs tmpfs 16G 9.1M 16G 1% /run
tmpfs tmpfs 16G 0 16G 0% /sys/fs/cgroup
/dev/vda1 ext4 79G 75G 315M 100% /
tmpfs tmpfs 3.2G 0 3.2G 0% /run/user/0

使用 lsblk 命令查看根分区,即
[root@fzoracle ~]# lsblk
NAME MAJ:MIN RM SIZE RO TYPE MOUNTPOINT
vda 253:0 0 200G 0 disk
└─vda1 253:1 0 80G 0 part /
vdb 253:16 0 500G 0 disk

磁盘空间不够就需要扩容,具体如何扩请查看这篇文章:https://support.huaweicloud.com/usermanual-evs/evs_01_0072.html#evs_01_0072__section143412109355 鄙人是根据它的相关步骤来进行扩的

扩完空间后,还想继续执行导入,该如何操作呢?
How to restart Datapump

  1. 在impdp 命令行下,执行 ctrl + c 来进行 导入任务的停止。

  2. 之后再import命令行进行如下操作进行停止
    Import> stop_job=immediate
    Are you sure you wish to stop this job ([yes]/no): yes

  3. 修复表空间错误

  4. Attach again the job. Check sqlplus>SELECT * FROM DBA_DATAPUMP_JOBS;
    使用类似于"SYS_IMPORT_FULL_*" 的名称

$impdp system/**** attach=SYS_IMPORT_FULL_01
5. 在导入的命令行中输入 start_job ,如下:
Import> start_job
6. Check sqlplus>SELECT * FROM DBA_DATAPUMP_JOBS; It is running again.

Logo

腾讯云面向开发者汇聚海量精品云计算使用和开发经验,营造开放的云计算技术生态圈。

更多推荐