Wednesday, March 26, 2008

Objects Remain In Their Original Tablespaces After Run Oatm

Migrated to the new tablespaces using OATM but there are objects left behind in original tablespaces. There were no errors reported during tablespace migration.

SQL> select tablespace_name, count(1) from dba_Segments group by tablespace_name;
TABLESPACE_NAME COUNT(1)
------------------------------ ----------
APPLSYSD 1
APPLSYSX 1
COMD 26
COMX 47
CTXD 77
EDWREP 88
EDWREPX 31
PVD 1
PVX 1

SQL> select segment_name, segment_type from dba_segments
2* where tablespace_name='APPLSYSD'
SEGMENT_NA SEGMENT_TYPE
---------- ------------------
20.42 SPACE HEADER

Cause
*******

One of the circumstances under which a 'SPACE HEADER' segment gets created is if a 'dictionary managed' tablespace is migrated to 'locally managed' (see dbms_space_admin.tablespace_migrate_to_local()).

The space header segment contains the extent bitmap and is allocated during the migration of the tablespace. Since there is no reserved space after the file header (as with locally managed tablespaces) the bitmap segment will be allocated somewhere in the "data" area of the datafile. During its creation the segment will pick up some of the storage attributes (e.g. MAXEXTENTS) from the default storage clause of the tablespace. Once the segment has been created it can neither be dropped nor changed.

Fix
****

You can ignore these "left-over" objects. Please go ahead and drop old tablespaces

13 Comments:

Microsoft Office 2007 said...

NEVERTHELESS, THE CIVIL LAW is and must be neutral about who has a more noble or rewarding faith. The breakaway parishes ought to win every Office 2010facet of the lawsuit not becauseMicrosoft Office 2010 their beliefs or their politics are better, Microsoft wordbut because both lawOffice 2007and equity, along with common sense, are on Microsoft Officetheir side.Microsoft Office 2007 Not only does Virginia state law (the Division Statute)Office 2007 keyexplicitly apply to just such a Office 2007 downloadsituation as now exists, but the history Office 2007 Professionalespecially of The Falls Church argues against the claims of Outlook 2010the Virginia Diocese with which theyMicrosoft outlookhave disassociated.Microsoft outlook 2010First, The Falls Church wasWindows 7 founded, formed, and developed long before the diocese, or the national Episcopal Church, even existed.

Anonymous said...

Incredible report,
Good drainage will offer
a tremendous effect around the environment, but you will find
a lot more important mindset encompassing residential greatly affect the cleanliness of
the city, if folks just throw trash everywhere can bring about drainage will be blocked
during the rainy season, and worse yet would outcome in flooding.
I strongly agree using the above article. Thank you and continue
to create articles or blog posts ..

my blog post - weight loss tips office workers

Anonymous said...

Thank you for another excellent composition. I have been looking around the net for revealing articles that can help me personally!
! Thanks for your time!!

Feel free to surf to my page; dental Pro 7 toothpaste

Anonymous said...

Finch; I realize that. Maybe I'm a moron (plausible), but I appear to be not able to locate a common denominator when employing search phrases, without incorporating a bunch. Sometimes I'll include like 10-15 for
one advert. Is the fact that standard?

Also visit my weblog ... tristan Hart

Anonymous said...

Yes, it is possible to mix all of these ingredients collectively in drinking water.
The only factor I advocate is the fact that
if you happen to be using bulk BCAA's (which I suggest making use of), is to first let it settle for about five -10 minutes as it has a tendency to foam up at first.

Feel free to surf to my website ... six pack abs shortcuts mike chang download

Anonymous said...

i agree with all statements talked about over and do you advice to perform to
gain at least five kg in a three weeks thank you

Here is my page ... building muscle mass In my legs

Anonymous said...

omg....i really like all of them! I would most likely utilize it for a craft workshop but the types as guest quarters
or romantic retreats are so fabulous! And i do backyard
so maybe I need 3!
susan prillman lately posted.

.Metal Star with Names of Jesus Aqua, Pink and White by glorygivers

my site ... arrow Sheds

Anonymous said...

But how would? you explain individuals like Carl Sagan and other people who went to general
public college, but grew to become great explorers and vital thinkers?
Surely not everybody is destined to grow to be an Albert Einstein
or Noam Chomsky, no matter the kind of schooling
method they knowledge. I'm not arguing along with your stage about consumerism, but then what would an ant colony be without having drones? Each and every social technique has a hierarchy due to differing amounts of ability or desire.

Visit my web page; Attract Women Through Honesty Download

Anonymous said...

Many thanks for the feedback. Singles populace is only one
factor we regarded as in assessing prime cities. As noted, work
opportunities carried much more bodyweight, as did
expense of living.

My blog - pick up women

Anonymous said...

Discount codes for the most part are for food items we usually do not consume.
My spouse retailers at shops that offer great meals
at minimal rates. I health supplement our purchases by acquiring extra items at Costco.



Also visit my web-site precision nutrition lean eating for women reviews

Anonymous said...

Asking questions are truly fastidious thing if you are not
understanding anything totally, however this post provides
pleasant understanding yet.

Have a look at my webpage; basyx By hon vl103

Anonymous said...

Hey, I think your site might be having browser compatibility issues.
When I look at your blog in Ie, it looks fine but when opening in Internet Explorer, it has some overlapping.
I just wanted to give you a quick heads up! Other then that,
terrific blog!

my blog; attraction shadow theatre group britains got talent 2013 auditions

Anonymous said...

Hi, I read your new stuff on a regular basis. Your
writing style is awesome, keep doing what you're doing!

my homepage :: where can i buy vigrx plus from