Re: Transportable tablespaces - space problem
- From: Robert Freeman <robertgfreeman@xxxxxxxxx>
- To: avramil@xxxxxxxxxxxxxx, oracle-l@xxxxxxxxxxxxx
- Date: Thu, 5 Jun 2008 09:05:40 -0700 (PDT)
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@xxxxxxxxxxxxxx>
To: oracle-l@xxxxxxxxxxxxx
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
--
//www.freelists.org/webpage/oracle-l
--
//www.freelists.org/webpage/oracle-l
Other related posts:
