Impdp import database times wrong ora - 39083 and ora

export data from one database to another database
Statements are derived: expdp CDBPPL/CDBPPL DIRECTORY=expdp DUMPFILE=CDBPPL. DMP version=11.1.0.6.0 schemas=CDBPPL;
Export without error,
Import statements are: impdp yanshi/yanshi123 DIRECTORY=bao DUMPFILE=CDBPPL. DMP REMAP_SCHEMA=CDBPPL: yanshi remap_tablespace=USERS: yanshi, CDBP: yanshi;
The export database space has two, one is CDBP is the USERS, and then when I import the map, but the import error, I was first created yanshi and object table space yanshi, specifies the yanshi this object is the default table space is yanshi,
Error message:
Handle object types SCHEMA_EXPORT/TABLE/TABLE
ORA - 39083: object type TABLE creation fails, an error:
ORA - 00959: a table space 'YANSHI; 'there is no
Failure of SQL is:
CREATE TABLE "YANSHI". "T_CDBPAPI_LOG" (" RETURN_OP_FLAG "VARCHAR2 (1000)," REQUEST_LENGTH "VARCHAR2 (100)," RESPONSE "VARCHAR2 (2000)," INTERFACE_NAME "VARCHAR2 (200)," ID "VARCHAR2 (32), the" REQUEST "VARCHAR2 (2000)," RETURN_MSG "VARCHAR2 (1000)," INTERFACE_END_TIME DATE ", "SPEND_TIME" NUMBER (7, 0), "INTERFACE_START_TIME DATE", "RESPONSE_LENGTH" VARCHAR2 (100), "CLIENT_IP" VARCHAR2 (100), "DATA_TOTAL" VARCHAR2 (100)) PCTFREE
ORA - 39083: object type TABLE creation fails, an error:
ORA - 00959: a table space 'YANSHI; 'there is no
Failure of SQL is:
CREATE TABLE "YANSHI". "T_USER_INFO" (" ID "VARCHAR2 (32)," CREATE_TIME "DATE," ACCOUNT "VARCHAR2 (32)," PASSWORD "VARCHAR2 (32)," SYS_TYPE_CODE "CHAR (1)," SYS_TYPE_NAME "VARCHAR2 (50)," STAFF_ID "VARCHAR2 (32)," PATIENT_ID "VARCHAR2 (32)," IDENTITY_NUMBER "VARCHAR2 (18)," EMAIL "VARCHAR2 (70)) PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 NOCOMPRESS LOGGING STORAGE (INITIAL 65536 NEXT 1048576 MINEXTENTS 1 the MAXEXTENTS 2147

Finally import after the completion of the inspection data, had 815 tables, only into 779 pieces, import a lot of times, I saw a baidu above are mapping table space, but I still can't solve, great spirit drive ah,

CodePudding user response:

remap_tablespace=USERS: YANSHI, CDBP: YANSHI;

ORA - 00959: a table space 'YANSHI; 'there is no

Are they not prompt you for a long time?

CodePudding user response:

. Big brother, I yanshi this is created, I am afraid you are wrong so I just wrote to create good yanshi the table space,,