Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> alter table move... question (logging/nologging)

alter table move... question (logging/nologging)

From: Syltrem <syltremzulu_at_videotron.ca>
Date: Fri, 29 Nov 2002 16:00:00 -0500
Message-ID: <ayQF9.19501$H67.88737@tor-nn1.netcom.ca>


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 address
Received on Fri Nov 29 2002 - 15:00:00 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US