Hey guys,
I'm trying to import a schema from a production db to a new one, but i'm getting the next error while doing the impdp:
Import: Release 12.1.0.2.0 - Production on Mar Jun 21 11:25:29 2016
Copyright (c) 1982, 2015, Oracle and/or its affiliates. All rights reserved.
;;;
Connected to: Oracle Database 12c Standard Edition Release 12.1.0.2.0 - 64bit Production
Master table "SYSTEM"."SYS_IMPORT_SCHEMA_01" upload/download complete
Initiating "SYSTEM"."SYS_IMPORT_SCHEMA_01": system/******** SCHEMAS=FETESA DIRECTORY=pos_full DUMPFILE=schemaFETESA.dmp LOGFILE=importSCHEMAFETESA.log
Procesing object type SCHEMA_EXPORT/USER
ORA-39083: Failed to create object type USER:"FETESA" with error:
ORA-65096: invalid common user or role name
expdp command i used: "expdp system/****** SCHEMAS=FETESA DIRECTORY=pos_full DUMPFILE=schemaFETESA.dmp LOGFILE=exportSCHEMAFETESA.log"
impdp command i used: "impdp system/****** SCHEMAS=FETESA DIRECTORY=pos_full DUMPFILE=schemaFETESA.dmp LOGFILE=importSCHEMAFETESA.log"
i'm using oracle 12c standard edition two
any ideas of what should i do??
thanks in advance!!