Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: RBS growing to size of disk after import
David Moore wrote:
>
> 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
Sounds like the datafile for the RBS tablespace has autoextend on - a
**very bad** idea (IMHO). Turn it off immediately then look into
shrinking it down.
-- Ron Reidy Oracle DBA Reidy Consulting, L.L.C.Received on Tue Nov 20 2001 - 11:29:11 CST