Re: Transportable tablespaces - space problem

From: Robert Freeman <robertgfreeman_at_yahoo.com>
Date: Thu, 5 Jun 2008 09:05:40 -0700 (PDT)
Message-ID: <847920.85354.qm@web38908.mail.mud.yahoo.com>


Are the block sizes in the two databases the same? Are you plugging in a different block size tablespace?

RF

 Robert G. Freeman
Author:
Oracle Database 11g New Features (Oracle Press) Portable DBA: Oracle (Oracle Press)
Oracle Database 10g New Features (Oracle Press) Oracle9i RMAN Backup and Recovery (Oracle Press) Oracle9i New Feature
Blog: http://robertgfreeman.blogspot.com (Oracle Press)

  • Original Message ---- From: Lou Avrami <avramil_at_concentric.net> To: oracle-l_at_freelists.org Sent: Thursday, June 5, 2008 9:31:40 AM Subject: Transportable tablespaces - space problem

Hello all,

Another group is having a transportable tablespace problem. I thought I'd run it by oracle-l and see if it sounds familiar to someone.

Two 40-gig tablepaces from a 10.2.0.1 database on Red Hat 4 were exported, moved to another Red Hat 4 server and imported into a 10.2.0.4 database. From what I have been told, the exact same daily data loads have been performed on both databases. What I've been told is that the tables in the 10.2.0.4 database are now taking up much more space than the tables in the 10.2.0.1 database.

The tablespaces are locally managed, using Automatic Segment Space Managment.

If anyone has any clues as to why this might be behaving this why, I'd appreciate it.

Thanks,
Lou Avrami

--

http://www.freelists.org/webpage/oracle-l
--

http://www.freelists.org/webpage/oracle-l Received on Thu Jun 05 2008 - 11:05:40 CDT

Original text of this message