locked
Clarification on tablespace RRS feed

  • 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