Import/Export and tablespace Size.
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: Import/Export and tablespace Size.

  1. #1
    Join Date
    May 2001
    Location
    Maryland, USA
    Posts
    409
    Hi,
    Everytime I import the database and export it back, I have noticed around 20% increase in Tablespace size. Is this normal? Or am I doing something wrong?

    With this increase in Tablespace size with every Import/export, The datafile soon gets filled up. I am using Oracle 8.1.7.2.5 on windows 2000.

    Thanks

    Dilip.
    -- Dilip

  2. #2
    Join Date
    Jan 2001
    Posts
    3,131
    Are you doing a FULL import and export?
    FULL will create tablespaces as specified in the export.
    Or are you talking about the used space in the tablespace?

    MH
    I remember when this place was cool.

  3. #3
    Join Date
    May 2001
    Location
    Maryland, USA
    Posts
    409
    Thanks hanky. No its user level exp/imp. My database has single user who owns all the database objects. Before importing the exported data, I am droping the user with cascade option.

    I am using this export/import method for my backup and restore. I know, exp/imp is not good for backup and restore functionality, but for now, I have to use import/export utility.

    The problem is If I do export and import of data 8-9 times without even entering any data, the tablespace gets filled up(I mean the used space keeps getting bigger). With full export/import, I did not face this problem.
    -- Dilip

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width