Home » RDBMS Server » Server Administration » Index Organized Table (Oracle 12)
Index Organized Table [message #635307] |
Thu, 26 March 2015 09:37  |
karthik4u
Messages: 36 Registered: September 2006 Location: CHENNAI
|
Member |
|
|
I have two oracle environment with similar configuration.
Creating index organized table is working in one environment but not in another environment.
I know that including OVERFLOW clause will solve this. But I want to know exact root cause why same IOT command working in one db and not in another db. These Dbs are similar and their tablespace blocksize too same.
Let me know where I need to check.
Thanks
|
|
|
|
|
|
|
|
|
|
|
Re: Index Organized Table [message #635600 is a reply to message #635307] |
Thu, 02 April 2015 03:22   |
karthik4u
Messages: 36 Registered: September 2006 Location: CHENNAI
|
Member |
|
|
Both are same.
From Working DB
SQL> select * from v$version;
BANNER CON_ID
-------------------------------------------------------------------------------- ----------
Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production 0
PL/SQL Release 12.1.0.2.0 - Production 0
CORE 12.1.0.2.0 Production 0
TNS for Solaris: Version 12.1.0.2.0 - Production 0
NLSRTL Version 12.1.0.2.0 - Production 0
SQL>
From Problematic DB
SQL> select * from v$version;
BANNER CON_ID
-------------------------------------------------------------------------------- ----------
Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production 0
PL/SQL Release 12.1.0.2.0 - Production 0
CORE 12.1.0.2.0 Production 0
TNS for Solaris: Version 12.1.0.2.0 - Production 0
NLSRTL Version 12.1.0.2.0 - Production 0
SQL>
I know this is some environment setup issue. But I need to identify the exact root cause. The same create table command works fine in one DB and not in another DB.
Tell me where I need to check.
--update: I've corrected your code tags. Please read the guidelines again, and this time do it properly.
[Updated on: Thu, 02 April 2015 03:31] by Moderator Report message to a moderator
|
|
|
|
|
|
Goto Forum:
Current Time: Sun May 04 20:55:32 CDT 2025
|