Oracle Database Discussions

hi all,

i have created a new database and moved schema X from 'A' database.After importing the schema X,I checked if all the objects have got imported in the new database and it got imported too.

But when i checked the size of the schema X in the new database using the command

select sum(bytes)/1024/1024/1024 from dba_segments where owner='SCHEMA X';

SUM(BYTES)/1024/1024/1024
-------------------------
18.6386108

After that I checked the size of the schema from the database from which i moved the schema


SQL> select sum(bytes)/1024/1024/1024 from dba_segments where owner='SCHEMA X';

SUM(BYTES)/1024/1024/1024
-------------------------
21.6172485

The schema X uses two tablespaces in 'A' Database (from where schema is imported).

I created only one tablespace and imported the schema to the new database.

Could anybody help me out on what could be the reason for size change.

Oracle Database : 8i


Thanks

Edited by: soundar on Aug 3, 2009 5:54 AM

Edited by: soundar on Aug 3, 2009 6:02 AM