export/import and datafile size

[a128]

Hi,

I have a database with 5GB of data. I created another database on a different server (initial size is much smaller than 5GB), exported only the schema from the 5GB database, and imported into the new database. The new database turns out to be about 5GB as well. Why is that? I thought exporting with schema only should turn out with much smaller size. Is my assumpotion wrong?

Thanks,

[nagarjuna]

Originally posted by a128
Hi,

I have a database with 5GB of data. I created another database on a different server (initial size is much smaller than 5GB), exported only the schema from the 5GB database, and imported into the new database. The new database turns out to be about 5GB as well. Why is that? I thought exporting with schema only should turn out with much smaller size. Is my assumpotion wrong?

Thanks,

You meant to say export the schame without any data ????

[Mr.Hanky]

Did you create your tablespaces ahead of time?
I would.

MH

[pando]

that's coz you exported with compress option, a no-no option

[a128]

Hi all,

Thank you all for the replies! However, I've tried it again without compression but it turned out to be the same. Here is the capture from my interactive export:
-----------------
Connected to: Oracle8i Release 8.1.7.3.0 - Production
JServer Release 8.1.7.3.0 - Production
Enter array fetch buffer size: 4096 >

Export file: expdat.dmp > schema_only100702.dmp

(1)E(ntire database), (2)U(sers), or (3)T(ables): (2)U >

Export grants (yes/no): yes >

Export table data (yes/no): yes > no

Compress extents (yes/no): yes > no

Export done in UTF8 character set and UTF8 NCHAR character set
Note: table data (rows) will not be exported

About to export specified users ...
User to be exported: (RETURN to quit) > gsn

User to be exported: (RETURN to quit) >

. exporting pre-schema procedural objects and actions
. exporting foreign function library names for user GSN
. exporting object type definitions for user GSN
About to export GSN's objects ...
. exporting database links
. exporting sequence numbers
. exporting cluster definitions
. about to export GSN's tables via Conventional Path ...
.......
---------------
The export was really fast so I am sure it only contained schema. Is there anything else I should look into to find out why the export turned out to be as big?

Thanks,

[a128]

BTW, to answer Mr. Hanky's question, I did create the tablespace ahead of time but with relatively small initial parameters. I'd rather let it grow if necessary during the import just to find out how big it is without the data.

Also, I dropped the tablespace before I've tried another import thus I am sure it started small.

Thanks,

[Mr.Hanky]

You do realize that you have NO DATA right, only the table structures.

MH

[a128]

Yes, I know. I don't want to import data. I only want to import schema to see how big the tablespace gets.

Thanks,