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 -> Re: Index Organized Table -- ORA-25182

Re: Index Organized Table -- ORA-25182

From: Jonathan Lewis <jonathan_at_jlcomp.demon.co.uk>
Date: Fri, 15 Oct 1999 20:27:57 +0100
Message-ID: <940015733.16416.0.nnrp-04.9e984b29@news.demon.co.uk>

Just an idle one but you could tty:

  1. Putting it in the default tablespace
  2. Putting it in the SYSTEM tablespace (Yes I do mean it)
  3. Swapping the order of the TABLESPACE and ORGANIZATION clauses (and other permutations including STORAGE)

--

Jonathan Lewis
Yet another Oracle-related web site: http://www.jlcomp.demon.co.uk

Chris Hamilton wrote in message ...
>On Fri, 15 Oct 1999 19:33:56 +0100, "Jonathan Lewis"
><jonathan_at_jlcomp.demon.co.uk> wrote:
>
>>Might be a bug;
>>I cut your text,
>>changed 64M to 64K
>>changed the tablespace name
>>and ran it under 8.0.5
>>Table created.
>
>I just tested it under 8.1.5, and it worked perfectly as is.
>
>Chris
>~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
>Christopher Hamilton
>Oracle DBA -- Sandbox.com
>chamilton_at_sandbox-inc.com
>http://www.sandbox.com/
Received on Fri Oct 15 1999 - 14:27:57 CDT

Original text of this message

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