| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
Home -> Community -> Usenet -> c.d.o.server -> alter table move... question (logging/nologging)
Oracle 81600
VMS 721
I need to move a (big) table from one tablespace to another. The table is
NOT partitioned.
The database is in archivelog mode, don't want to shut it down, don't want
to generate tons of redo logs.
Is it safe to do ALTER TABLE MOVE ... NOLOGGING ?
What exactly happens then? You can make a reference to the manual, I'll be glad to read all the details in there.
Will the old table be dropped only when it is successfully moved to the
other tablespace?
If I use NOLOGGING, is the safeguard to a) EXPort data just in case, MOVE,
backup old and new tablespaces.
I would think backup old tablespace is required because it would be hard to
apply archived logs to it (if needed for eventual recovery), when the table
really is gone. Don't know. That's why I'm asking, I'd like to understand
what goes on when I do this.
Thanks.
-- Syltrem http://pages.infinit.net/syltrem (OpenVMS related web site - en français) To reply to myself directly, remove zulu from my addressReceived on Fri Nov 29 2002 - 15:00:00 CST
![]() |
![]() |