Clarification on tablespace

Question

User779033375 posted

Hi,

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.

Clarification:

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.

Answer 1

User1207305026 posted

You should make the new tablesapce as default tablespace for the user, otherwise the data by default goes to the users tablespace in Oracle.

Answer 2

User779033375 posted

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.

Answer 3

User1013750657 posted

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 :) )

select * from dba_tables where upper(table_name) = 'YOUR_TABLE_NAME';