Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Moving tables between tablespaces?
In article <aff1pk$dod3k$1_at_ID-84852.news.dfncis.de>,
"[ste parker]" <imaginey_at_hotmail.com> wrote:
> Hi,
> I'm having a problem at the moment for which the solution is 1.
> Recompile a program, or 2. Change the tablespace that two tables reside in,
> so the program works as intended.
>
> 1. Is difficult, as I don't have the source code, and if I did I'd have to
> set up a build environment, and unfortunately there's no time for that.
>
> 2. Seems reasonable enough to me, but the DBA who would have to carry this
> out says he'd have to "restructure the whole database", which I thought odd.
> It might be a language thing, but I would have thought that it would be
> simple enough to create another tablespace with the same extents etc, just
> not called "AS" this time, then move the two tables into the new tablespace.
> If this is a bad/wrong/difficult thing to do, could someone please explain
> why to me? Also, if it isn't an unreasonable thing to do, can someone tell
> me exactly what needs to be done to do this (under Oracle 8.1.6), so I can
> put a proper proposal forward?
It sounds to me like your DBA is either (a) timid, (b) lazy, or (c) incompetent. Of course, I don't know the full scope of your environment, so there may be other issues at hand, but here's how I might go about doing what you describe:
During a period of inactivity (forced or scheduled), or on a test instance, I would
Please note that I've only provided an overview to the process. I have not included determining sizing, time to completion, etc. However, please also consider that I've actually performed this maneuver more than once, without any ill effect. However, I'm concerned that the application code, if it contains embedded references to tablespaces, is violating the concept of "independence between data and data objects." This might cause me to be very cautious about step 6.
-- The underscore character does not belong in my address. You know the drill... *** Anyone sufficiently smart enough to configure and use USEnet for research should be smart enough to Read The Freakin' Documentation!Received on Thu Jun 27 2002 - 08:28:50 CDT