Answered by:
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.
Tuesday, March 27, 2012 4:44 AM
Answers
-
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.
- Marked as answer by Anonymous Thursday, October 7, 2021 12:00 AM
Tuesday, March 27, 2012 5:16 AM -
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';
- Marked as answer by Anonymous Thursday, October 7, 2021 12:00 AM
Sunday, April 15, 2012 8:04 AM
All replies
-
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.
- Marked as answer by Anonymous Thursday, October 7, 2021 12:00 AM
Tuesday, March 27, 2012 5:16 AM -
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.
Wednesday, April 4, 2012 1:08 AM -
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';
- Marked as answer by Anonymous Thursday, October 7, 2021 12:00 AM
Sunday, April 15, 2012 8:04 AM