IMPDP for transportable tablespace 'TOOLS' not showing tablespace's detail after successfull comple
Hi,
I am facing a very strange issue, my db detail is as below.
Platform :- HP-UX B.11.11
Oracle :-10.2.0.3.0
Issue:- I have a requirement where i have to import TOOLS tablespace in dev database environment which was exported from production that also with the help of TTS.
(expdp performed with all the pre-requisite successfully verified)
when i run the metadata impdp command it shows it completed successfully , when i am trying to see the tablespace detail it is not avaialable in DB. i am using below parfile .
Looking suggestion if you have encountered earlier.
SQL> select TABLESPACE_NAME,FILE_NAME from dba_data_files where TABLESPACE_NAME like '%TOOL%';
I am facing a very strange issue, my db detail is as below.
Platform :- HP-UX B.11.11
Oracle :-10.2.0.3.0
Issue:- I have a requirement where i have to import TOOLS tablespace in dev database environment which was exported from production that also with the help of TTS.
(expdp performed with all the pre-requisite successfully verified)
when i run the metadata impdp command it shows it completed successfully , when i am trying to see the tablespace detail it is not avaialable in DB. i am using below parfile .
Looking suggestion if you have encountered earlier.
SQL> select TABLESPACE_NAME,FILE_NAME from dba_data_files where TABLESPACE_NAME like '%TOOL%';
0