RBS growing to size of disk after import

Hi,
  I'm running oracle 8.1.7 on 2 different machines. I'm trying to get a database from one machine to the other. I used the exp command like so:

C:\dump\foo>exp system/manager owner=agile file="""c:\dump\foo\mydb.dmp""" lo
g="""c:\dump\foo\mydb.log"""

which worked fine. no errors or anything. It produced a 14 MB dump file (not a really big database).

Then when I move it over to the new oracle machine and do:

imp system/manager fromuser=agile touser=agile file=mydb.dmp

it imports successfully but grows the RBS to like 6.7 GB!!!

so here's some questions:
1.) any way to dump the RBS so that it will go down to something more reasonable (like 100 MB)
2.) is there something wrong w/ the way i'm moving the DB?

3.) any other advice?

-dave Received on Tue Nov 20 2001 - 10:15:05 CST