Hi,
Source db : Oracle 10.2.0.4
Win : Win 2003
Target : Oracle 12.2.0.1
Win : Win 2012
I did a datapump export from Source for specific schema, and when i run the datapump import command, it seems it's trying to create user in cdb, which obviously i don't want. Even though i have specified my pdb service name, it's not working that way
impdp system service_name=pdbcusdev directory=imp_12c dumpfile=custtest_dp_11252015_%U_exp.dmp logfile=impdp_datapump_11302015.log PARALLEL=4
select * from v$services;
PDBCUSDEV
CDB$ROOT
CDB$ROOT
CDB$ROOT
CDB$ROOT
Here's the out of my listener status
C:\Windows\system32>lsnrctl status
LSNRCTL for 64-bit Windows: Version 12.1.0.2.0 - Production on 30-NOV-2015 16:14:54
Copyright (c) 1991, 2014, Oracle. All rights reserved.
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=172.17.61.136)(PORT=1521)))
STATUS of the LISTENER
------------------------
Alias LISTENER
Version TNSLSNR for 64-bit Windows: Version 12.1.0.2.0 - Production
Start Date 30-NOV-2015 15:58:39
Uptime 0 days 0 hr. 16 min. 19 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Listener Parameter File F:\app\oraclehomeuserdev\product\12.1.0\dbhome_1\network\admin\listener.ora
Listener Log File F:\app\oraclehomeuserdev\diag\tnslsnr\TELAUSB2B2141\listener\alert\log.xml
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=172.17.61.136)(PORT=1521)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(PIPENAME=\\.\pipe\EXTPROC1521ipc)))
Services Summary...
Service "CLRExtProc" has 1 instance(s).
Instance "CLRExtProc", status UNKNOWN, has 1 handler(s) for this service...
Service "cusdev" has 1 instance(s).
Instance "cusdev", status READY, has 1 handler(s) for this service...
Service "cusdevXDB" has 1 instance(s).
Instance "cusdev", status READY, has 1 handler(s) for this service...
Service "pdbcusdev" has 1 instance(s).
Instance "cusdev", status READY, has 1 handler(s) for this service...
The command completed successfully
The reason why i am confident that it's trying to create stuff in cdb is the first error that i got was "ORA-65096: invalid common user or role name" which gave me a hint that it's trying to create a user in cdb instead of pdb.
How do i force the datapump to push data into pdb. I thought service_name parameter of impdb command is sufficient.What am i missing here ?
Also fyi, i was able to connect to cdb and pdb through Toad and query the dict count to ensure that i do see a diff. no. against "select * from dict"
-Learner