Last post Apr 15, 2012 08:04 AM by ruipedromachado
Mar 27, 2012 04:44 AM|saffy|LINK
We have 1.30 GB oracle dump file .DMP file
we have created on user and tablespace in E drive. by default Tablespace size is 20 MB
we have imported 1.30 GB dump file to newly created user using "IMPDP " command.
Its imported successfully, but still tablespace size in 20 MB only.
Does new imported data stored in E drive table space?
If so why tablespace is is still 20 MB only?
If not where can i find the imported data?
Can u please suggest.
Mar 27, 2012 05:16 AM|kgashi|LINK
You should make the new tablesapce as default tablespace for the user, otherwise the data by default goes to the users tablespace in Oracle.
Apr 04, 2012 01:08 AM|saffy|LINK
Yes, we have made it default.
How can I know data is storing in default table space only. because DMP file is 1GB but Tablespace file is 20 MB.
Apr 15, 2012 08:04 AM|ruipedromachado|LINK
if the dump imported successfully then the data is there somewhere.
analyse your dba_users it holds all the information for the user.
select * from dba_users;
if you still cant make sence if it , try looking for tables that you just imported ( well....if you know one of the tables name :) )