Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: ALTER TABLE...ADD PARTITION...TABLESPACE <tablespace_name> fails
The move command is synchronous.
Generically, v$session_longops gives information per session about the progress of long-running activities. I haven't checked it for the MOVE command.
BTW - I haven't run the bug completely to ground, since I got the 8.1.7.1 fix very quickly, but I think if try to get 3 moves running concurrently you will get an ora_00600; if you restrict yourself to 2, you will only hit the problem if they start within a couple of seconds of each other.
-- Jonathan Lewis Yet another Oracle-related web site: http://www.jlcomp.demon.co.uk Practical Oracle 8i: Building Efficient Databases Publishers: Addison-Wesley Reviews at: http://www.jlcomp.demon.co.uk/book_rev.html Neoteric5 wrote in message ...Received on Thu May 10 2001 - 08:07:44 CDT
>Thanks, Jonathan! Certainly, it is not yet fixed in 8.1.7.0.
>
>(1) Are such partition moves synchronous with the ALTER TABLE...MOVE
>PARTITION statement, or does background work continue in the Oracle server
>after the statement returns?
>
>In other words, if I do this:
>
>------------------cut here 8<------------------
>ALTER TABLE...ADD PARTITION P1...
>ALTER TABLE...MOVE PARTITION P1...
>ALTER TABLE...ADD PARTITION P2...
>ALTER TABLE...MOVE PARTITION P2...
>------------------cut here 8<------------------
>
>in a single SQL script, is it possible to get the 00600 error, or is the P1
>move guaranteed to be complete before the P2 move begins?
>
>(2) Is there a system table or view I can query that shows the progress of
>the partition move, so that I can serialize the multiple moves explicitly?
>
>(I ask this because I've noticed that when using a tool like Oracle DBA
>Studio, *some* commands seem to continue executing on the server after
>control returns to the application.)
>
>Thanks!
>-Milo Chan