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
Wednesday, March 26, 2008
Objects Remain In Their Original Tablespaces After Run Oatm
Posted by M A D A N M O H A N at 5:51 PM
Subscribe to:
Post Comments (Atom)
12 Comments:
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
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
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
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
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
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
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
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
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
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
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
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
Post a Comment