Re: How to use the Unused Column?

From: jaromir nemec <jaromir_at_db-nemec.com>
Date: Tue, 19 Dec 2006 22:53:56 +0100
Message-ID: <15f101c723b8$30024c00$3c02a8c0@JARAWIN>

Hi,

> Nice to be aware of that side effect, ..

I minor issue is the problem with exchange partition. Both the table and the partition must have same (or compatible) columns *AND* same list of unused columns (otherwise ORA-14097 is raised). This is sometimes overlooked if the exchange table is created dynamically based on user_tab_columns only. USER_UNUSED_COL_TABS must be considered as well.

Jaromir

Original Message ----- From: Niall Litchfield To: ganstadba_at_hotmail.com Cc: oracle-l_at_freelists.org Sent: Tuesday, December 19, 2006 10:08 PM Subject: Re: How to use the Unused Column?

On 12/19/06, Michael McMullen <ganstadba_at_hotmail.com> wrote: Downside is exports can only be in conventional mode.

Nice to be aware of that side effect, does it have similar effects on other direct path operations?

  --
  Niall Litchfield
  Oracle DBA
  http://www.orawin.info

--
http://www.freelists.org/webpage/oracle-l

Received on Tue Dec 19 2006 - 15:53:56 CST