rodrigosilvaesilva – Página: 13 – Rodrigo Silva e Silva

Verificando NLS_NCHAR_CHARACTERSET e NLS_CHARACTERSET

Publicado em 14 de setembro de 2018 by rodrigosilvaesilva

SYS@BDORA> column PARAMETER format a35;

SELECT * FROM NLS_DATABASE_PARAMETERS 
WHERE PARAMETER IN ('NLS_NCHAR_CHARACTERSET','NLS_CHARACTERSET');

PARAMETER                           VALUE
----------------------------------- ----------------------------------------------------------------
NLS_NCHAR_CHARACTERSET              AL16UTF16
NLS_CHARACTERSET                    WE8MSWIN1252

SYS@BDORA> column PARAMETER format a35;

SELECT * FROM NLS_DATABASE_PARAMETERS

WHERE PARAMETER IN ('NLS_NCHAR_CHARACTERSET','NLS_CHARACTERSET');

PARAMETER VALUE

----------------------------------- ----------------------------------------------------------------

NLS_NCHAR_CHARACTERSET AL16UTF16

NLS_CHARACTERSET WE8MSWIN1252

Creating PERFSTAT usercreate user perfstat*ERROR at line 1:ORA-01920: user name ‘PERFSTAT’ conflicts with another user or role name

Publicado em 11 de setembro de 2018 by rodrigosilvaesilva

ERRO: Creating PERFSTAT usercreate user perfstat*ERROR at line 1:ORA-01920: user name ‘PERFSTAT’ conflicts with another user or role name

SQL> @?/rdbms/admin/spcreate
Choose the PERFSTAT user's password [password]
Choose the Default tablespace for the PERFSTAT user [PERFSTAT]<--I had to create it
Choose the Temporary tablespace for the PERFSTAT user [TEMP]


Using tablespace TEMP as PERFSTAT temporary tablespace.


... Creating PERFSTAT user
create user perfstat
*
ERROR at line 1:
ORA-01920: user name 'PERFSTAT' conflicts with another user or role name

SQL> @?/rdbms/admin/spcreate

Choose the PERFSTAT user's password [password]

Choose the Default tablespace for the PERFSTAT user [PERFSTAT]<--I had to create it

Choose the Temporary tablespace for the PERFSTAT user [TEMP]

Using tablespace TEMP as PERFSTAT temporary tablespace.

... Creating PERFSTAT user

create user perfstat

ERROR at line 1:

ORA-01920: user name 'PERFSTAT' conflicts with another user or role name

SQL> @?/rdbms/admin/spdrop.sql
.....
....
...
..


drop view           STATS$X_$KSPPSV
*
ERROR at line 1:
ORA-00942: table or view does not exist


drop public synonym  STATS$X$KSPPSV
                     *
ERROR at line 1:
ORA-01432: public synonym to be dropped does not exist


drop view           STATS$X_$KSPPI
*
ERROR at line 1:
ORA-00942: table or view does not exist


drop public synonym  STATS$X$KSPPI
                     *
ERROR at line 1:
ORA-01432: public synonym to be dropped does not exist


drop view           STATS$X_$KSXPPING
*
ERROR at line 1:
ORA-00942: table or view does not exist


drop public synonym  STATS$X$KSXPPING
                     *
ERROR at line 1:
ORA-01432: public synonym to be dropped does not exist


drop view           STATS$V_$FILESTATXS
*
ERROR at line 1:
ORA-00942: table or view does not exist


drop public synonym  STATS$V$FILESTATXS
                     *
ERROR at line 1:
ORA-01432: public synonym to be dropped does not exist


drop view           STATS$V_$SQLXS
*
ERROR at line 1:
ORA-00942: table or view does not exist


drop public synonym  STATS$V$SQLXS
                     *
ERROR at line 1:
ORA-01432: public synonym to be dropped does not exist


drop view           STATS$V_$TEMPSTATXS
*
ERROR at line 1:
ORA-00942: table or view does not exist


drop public synonym  STATS$V$TEMPSTATXS
                     *
ERROR at line 1:
ORA-01432: public synonym to be dropped does not exist


drop view           STATS$V_$SQLSTATS_SUMMARY
*
ERROR at line 1:
ORA-00942: table or view does not exist


drop public synonym  STATS$V$SQLSTATS_SUMMARY
                     *
ERROR at line 1:
ORA-01432: public synonym to be dropped does not exist



User dropped.

SQL> @?/rdbms/admin/spdrop.sql

.....

....

...

drop view STATS$X_$KSPPSV

ERROR at line 1: