Re: Table with data but not segment
Date: Fri, 30 Jan 2009 08:04:55 -0800 (PST)
Message-ID: <946203.64966.qm_at_web38907.mail.mud.yahoo.com>
I'd also check with Oracle. As I recall, the remapping functions in Data Pump had a few bugs. This might be the case here.
RF
Robert G. Freeman
Author:
OCP: Oracle Database 11g Administrator Certified Professional Study Guide (Sybex)
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 Features (Oracle Press)
Other various titles out of print now...
Blog: http://robertgfreeman.blogspot.com
The LDS Church is looking for DBA's. You do have to be a Church member in
good standing. A lot of kind people write me, concerned I may be breaking
the law by saying you have to be a Church member. It's legal I promise! :-)
- Original Message ---- From: "Joel.Patterson_at_crowley.com" <Joel.Patterson_at_crowley.com> To: Oracle-L_at_freelists.org Sent: Friday, January 30, 2009 8:36:07 AM Subject: Table with data but not segment
I would like to clarify or confirm. I can query (user_tables union user_indexes) minus user_segments and see about 4 tables and 9 indexes. 7 turn out to be normal and 2 are IOT - TOP indexes.
I guess the 3 tables with 0 rows and all the indexes that go with them might not have a segment?
There is one table with and IOT - TOP index with 100000 rows. Two indexes go with this table, one of them is IOT - TOP, the other normal.
Even and Index has a segment, why would I not have a segment for this(ese) table(s) or Indexes?
--
http://www.freelists.org/webpage/oracle-l
--
http://www.freelists.org/webpage/oracle-l
Received on Fri Jan 30 2009 - 10:04:55 CST