Unable to start import for a dump file which is exported from 12c db. Please find the error displayed below. Request some one to help me out with this issue.
$ impdp userid=DBL1203UBS/******@YESBANKUPG DIRECTORY=DATA_PUMP_DIR DUMPFILE=UBS1203WPS_FULL_DUMP.dmp LOGFILE=UBS1203WPS_FULL_DUMP.LOG remap_schema=UBS1203WPS:DBL1203UBS remap_tablespace=UBS1203WPS:DBL1203UBS
Import: Release 12.1.0.2.0 - Production on Thu Feb 18 14:01:22 2016
Copyright (c) 1982, 2014, Oracle and/or its affiliates. All rights reserved.
Connected to: Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options
ORA-31626: job does not exist
ORA-31633: unable to create master table "DBL1203UBS.SYS_IMPORT_FULL_05"
ORA-06512: at "SYS.DBMS_SYS_ERROR", line 95
ORA-06512: at "SYS.KUPV$FT", line 1048
ORA-60019: Creating initial extent of size 14 in tablespace of extent size 8
The table space is created with the command
create tablespace DBL1203UBS datafile '/scratch/oracle/app_12.1.0.2/oradata/YESBANKUPG/DBL1203UBS.dbf' size 50m autoextend on maxsize 20G extent management local uniform size 64K;
Hope the table space is not a issue as i had added another database file to the table space and executed the same command.
I am trying this in a Unix machine. i am able to create a table if i login into the database DBL1203UBS from plsqldeveloper.
I have tried executing the commands like alter user DBL1203UBS quota unlimited on USERS. still the same issue.
I had posted this in the oracle apex discussions where i was told to put this discussion in General Database Discussions. Please help..