Hello, Indeed I should not create object with SYS.
I have restarted from a fresh image (Docker)
And restart step-by-step.
But this time, I have created a new schema (with SYSTEM).

ALTER SESSION SET "_ORACLE_SCRIPT"= true;
CREATE TABLESPACE MYUSR DATAFILE '/opt/oracle/oradata/ORCLCDB/MYUSR' SIZE 100 M AUTOEXTEND ON NEXT 100 M MAXSIZE 10 G;
CREATE USER MYUSR IDENTIFIED BY "eqntqgiwxp1$" DEFAULT TABLESPACE MYUSR;
GRANT CONNECT, RESOURCE TO MYUSR;
GRANT UNLIMITED TABLESPACE TO MYUSR;
GRANT CREATE VIEW TO MYUSR;

And when connected as MYUSR I try to create the tables I have the error for both types.

SQL> create table testvc (name varchar2(32676));
create table testvc (name varchar2(32676))
                                   *
ERROR at line 1:
ORA-00910: specified length too long for its datatype


SQL> create table testnvc (name nvarchar2(4000));
create table testnvc (name nvarchar2(4000))
                                          *
ERROR at line 1:
ORA-00910: specified length too long for its datatype

Please see if your issue regarding PDBs is the same here : https://www.markusdba.net/2016/10/23/switching-a-multitenant-database-to-extended-data-types/

Hi J. Laurindo Chiappa,
Base on https://docs.oracle.com/en/database/oracle/oracle-database/21/refrn/MAX_STRING_SIZE.html#GUID-D424D23B-0933-425F-BC69-9C0E6724693C what I understood is that the "The --force_pdb_mode ‘UPGRADE’ option is used to ensure that all PDBs, including application root clones, are opened in migrate mode" so all PDBs should be upgraded too...

yep, it was exactly what was done in the article : let's see if it WAS the issue for Jean-Philippe., or not....

create the table with 32K It will work. Hope it helps 32637 is too high that is why it is failing

No, sir : as https://www.gbmb.org/kb-to-bytes show to us, 32 KB are 32768 bytes - due to the string-ending CHR(0) eventually present, the real maximum limit isn't 32768 but 32767 :

APP_OWNER@db_app::CNTNR=DB_APP> create table testvc2 (name varchar2(32768));
create table testvc2 (name varchar2(32768))
*
ERROR in line 1:
ORA-00910: specified length too long for its datatype


APP_OWNER@db_app::CNTNR=DB_APP> create table testvc2 (name varchar2(32767));

Table created.

APP_OWNER@db_app::CNTNR=DB_APP> @desc testvc2
Nome Nulo? Tipo
----------------------------------------- -------- ----------------------------
NAME VARCHAR2(32767)

===> 32637 is LESS THAN 32767 , so it works, too :

APP_OWNER@db_app::CNTNR=DB_APP> create table testvc3 (name varchar2(32637));

Table created.

APP_OWNER@db_app::CNTNR=DB_APP>

https://pastebin.com/BzjDkivL is a pastebin with the step by step applying the 32k script on CDB and all of my PDBs and thus being able to create 32k strings, absolutely an easy task....

I tried the pastbin.
Despite that the parameter seems to be well set, it does not work.

The schema I create is still receiving the error...

Just for the information this is the version I am working with.
Oracle Database 21c Enterprise Edition Release 21.0.0.0.0 - Production
Version 21.3.0.0.0

if you have followed the instructions contained in pastebin and it still doesn't work, there is no other alternative but to open a Support Ticket : please include on the Ticket the output of the 32k script (for ALL the PDBs AND for root container) and the messages in alert.log.

Regards,

J. Laurindo Chiappa

Hello,
I just made another test, I have added the -initParams max_string_size=EXTENDED in the command line when creating the database.

sh-4.2$ sqlplus / as sysdba

SQL*Plus: Release 21.0.0.0.0 - Production on Mon Aug 8 11:23:39 2022
Version 21.3.0.0.0

Copyright (c) 1982, 2021, Oracle.  All rights reserved.


Connected to:
Oracle Database 21c Enterprise Edition Release 21.0.0.0.0 - Production
Version 21.3.0.0.0

SQL> show parameter max_string_size;

NAME         TYPE  VALUE
------------------------------------ ----------- ------------------------------
max_string_size        string  EXTENDED

So I connected as system (sqlplus system) and created the schema MYUSR.

But it is not working either I sill have the errors

sh-4.2$ sqlplus MYUSR

SQL*Plus: Release 21.0.0.0.0 - Production on Mon Aug 8 11:25:11 2022
Version 21.3.0.0.0

Copyright (c) 1982, 2021, Oracle.  All rights reserved.

Enter password: 

Connected to:
Oracle Database 21c Enterprise Edition Release 21.0.0.0.0 - Production
Version 21.3.0.0.0

SQL> create table testvc (name varchar2(32676));
create table testvc (name varchar2(32676))
                                   *
ERROR at line 1:
ORA-00910: specified length too long for its datatype

SQL> create table testnvc (name nvarchar2(4000));
create table testnvc (name nvarchar2(4000))
                                          *
ERROR at line 1:
ORA-00910: specified length too long for its datatype

Very strange that even with an fresh installation which by default is set as "extended" it does not work.

First, just saying, it's not enough just "add the parameter max_string_size=EXTENDED" in CDB and in all of the PDBs (INCLUDING PDB$SEED , please) : you really Need beside that to run (AFTER a database restart) the utl32k.sql script in CDB AND in all PDBs , AND the script must finish WITHOUT ANY ERRORS, specially ORA-01722, AND the COMPATIBLE parameter in CDN AND in ALL of the PDBs must be set to (minumim) 12.1.xxx , or greater...
AND, really, this kind of error :

create table testnvc (name nvarchar2(4000))
*
ERROR at line 1:
ORA-00910: specified length too long for its datatype

==> really leads us to think about non-complete tasks : it looks like even the "native" limit of 4000 bytes is broken...

IF you did it ALL, don't forgeting ANY step, in the RIGHT order and without receiving ANY errors, all I can say is , again, please open a Support ticket, much probably you have some kind of bug in your hands....

Hello,
I have tried again to validate that I have followed ALL the STEPS, in the RIGHT ORDER as provided.
I have also tried after creating the schema MYUSR before the update.
No success...
I have also tried with a 19c (still docker)
Following the documentation: https://docs.oracle.com/en/database/oracle/oracle-database/19/refrn/MAX_STRING_SIZE.html#GUID-D424D23B-0933-425F-BC69-9C0E6724693C
And also with the steps provided here.
No success...
Would it be linked to the docker implementation?

Nvarchar2
The maximum value is:
16383 if MAX_STRING_SIZE = EXTENDED and the national character set is AL16UTF16
32767 if MAX_STRING_SIZE = EXTENDED and the national character set is UTF8
2000 if MAX_STRING_SIZE = STANDARD and the national character set is AL16UTF16
4000 if MAX_STRING_SIZE = STANDARD and the national character set is UTF8