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 -> conversion from range part tab to regular table

conversion from range part tab to regular table

From: Ted Chyn <tedchyn_at_yahoo.com>
Date: 29 Oct 2001 16:56:29 -0800
Message-ID: <44a19320.0110291656.177dedf1@posting.google.com>


sir, I have 16 partitions table, what is the best way of converting them into a regular table. exchange option only allows me to do one partition at a time. In addition there are logging involved.

export and import is another approach again logging is involved with that too. Is it possible move nologging and change storage parameter to a nonpartition table ?

thnx ted chyn Received on Mon Oct 29 2001 - 18:56:29 CST

Original text of this message

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