SOLVED: Re: ora-00972 in 12.2.0.1 database?
From: Lyall Barbour <lyallbarbour_at_sanfranmail.com>
Date: Tue, 19 Mar 2019 14:45:36 +0100
Message-ID: <trinity-e57e1059-b337-4e27-9307-f0795961fa9e-1553003136591_at_3c-app-mailcom-lxa16>
-- http://www.freelists.org/webpage/oracle-l
--
http://www.freelists.org/webpage/oracle-l
Received on Tue Mar 19 2019 - 14:45:36 CET
Date: Tue, 19 Mar 2019 14:45:36 +0100
Message-ID: <trinity-e57e1059-b337-4e27-9307-f0795961fa9e-1553003136591_at_3c-app-mailcom-lxa16>
Of course, i didn't set the COMPATIBLE parameter in this environment.
oh... the little things that get ya.
Lyall
Sent: Monday, March 18, 2019 at 1:01 PM
From: "Lyall Barbour" <lyallbarbour_at_sanfranmail.com>
To: oracle-l <oracle-l_at_freelists.org>
Subject: ora-00972 in 12.2.0.1 database?
From: "Lyall Barbour" <lyallbarbour_at_sanfranmail.com>
To: oracle-l <oracle-l_at_freelists.org>
Subject: ora-00972 in 12.2.0.1 database?
Hello,
RDBMS version 12.2.0.1 PSU July 2018
I am redefining some partitions in an system that has been around forever. I'm my first test, there were issues, but ultimately my scripts worked.
next test in a database that very similar to the first. 12.2.0.1, same OS. But there some differences. PSU is older, database is bigger/more data, block size (even). But in this new test in the other database, i immediately get ora-00972 when i create my INTERIM table.
I've read on blogs that you can still get caught with the sizes of names if your character set is large and using intense names, but... this is just english and WE NLS Character set.
Any one have problems with the 12.2 new 128 character sizes for structure names?
Lyall