数据库(Oracle管理)
Oct 19
ORA-29275: partial multibyte character tips(FROM WEB) http://www.dba-oracle.com/t_ora_29275_partial_multibyte_character.htm

网上查找的一个解决方式
                  Oracle Database Tips by Donald BurlesonJuly 13, 2015
            
      
                 
          

           

          

          Question:  Am I getting the ORA-29275            error on a SQL query.  How can I find the affected rows            and how to I fix the data to remove the ORA-29275 error?

          

           

          

          Answer:  The oerr            utility gives us this information on the ORA-29275 error:

          

          

          

          ORA-29275: partial multibyte character
          
Cause: The requested read operation            could not complete because a partial multibyte character was            found at the end of the input.

Action:           Ensure that the complete multibyte character is            sent from the remote server and retry the operation. Or read            the partial multibyte character as RAW.

          

          

          

          The core issue of that the nls_chracterset values            for the multibyte character set does not match between            either two databases in a distributed query, or a query            where the webserver has a different character set.             There are several possible fixes for the ORA-29275 error,            all involving getting the NLS character sets to match:

          

           

          

          1 - write a function to convert each row.  Place this            function inside a PL/SQL function and call it for each row            of the table:

CONVERT(COLUMN            NAME,'NLS_CHARACTERSET','NLS_CHARACTERSET');

2 - If            you have a webserver, try setting the NLS_LANG environmental            variable on the webserver to american_america.al32utf8.

          

          

          

          References:

          

          
See MOS Note 69518.1 - Storing and Checking Character            Codepoints in an UTF8/AL32UTF8 (Unicode) database.

          

          

          

          See MOS Note                     788156.1 - AL32UTF8 / UTF8 (Unicode) Database            Character Set Implications

Tags: ,
Jul 29
V$SQLCOMMAND SQL opcodes and names的查询,具体以实际查询的为准,以下仅供参考
由itlife365收集
--begin
SQL> select command_type,command_name from V$SQLCOMMAND;

COMMAND_TYPE COMMAND_NAME
------------ ----------------------------------------------------------
           0
           1 CREATE TABLE
           2 INSERT
           3 SELECT
           4 CREATE CLUSTER
           5 ALTER CLUSTER
           6 UPDATE
           7 DELETE
           8 DROP CLUSTER
           9 CREATE INDEX
          10 DROP INDEX
          11 ALTER INDEX
          12 DROP TABLE
          13 CREATE SEQUENCE
          14 ALTER SEQUENCE
          15 ALTER TABLE
          16 DROP SEQUENCE
          17 GRANT OBJECT
          18 REVOKE OBJECT
          19 CREATE SYNONYM
          20 DROP SYNONYM
          21 CREATE VIEW
          22 DROP VIEW
          23 VALIDATE INDEX
          24 CREATE PROCEDURE
          25 ALTER PROCEDURE
          26 LOCK TABLE
          27 NO-OP
          28 RENAME
          29 COMMENT
          30 AUDIT OBJECT
          31 NOAUDIT OBJECT
          32 CREATE DATABASE LINK
          33 DROP DATABASE LINK
          34 CREATE DATABASE
          35 ALTER DATABASE
          36 CREATE ROLLBACK SEG
          37 ALTER ROLLBACK SEG
          38 DROP ROLLBACK SEG
          39 CREATE TABLESPACE
          40 ALTER TABLESPACE
          41 DROP TABLESPACE
          42 ALTER SESSION
          43 ALTER USER
          44 COMMIT
          45 ROLLBACK
          46 SAVEPOINT
          47 PL/SQL EXECUTE
          48 SET TRANSACTION
          49 ALTER SYSTEM
          50 EXPLAIN
          51 CREATE USER
          52 CREATE ROLE
          53 DROP USER
          54 DROP ROLE
          55 SET ROLE
          56 CREATE SCHEMA
          57 CREATE CONTROL FILE
          58 ALTER TRACING
          59 CREATE TRIGGER
          60 ALTER TRIGGER
          61 DROP TRIGGER
          62 ANALYZE TABLE
          63 ANALYZE INDEX
          64 ANALYZE CLUSTER
          65 CREATE PROFILE
          66 DROP PROFILE
          67 ALTER PROFILE
          68 DROP PROCEDURE
          70 ALTER RESOURCE COST
          71 CREATE MATERIALIZED VIEW LOG
          72 ALTER MATERIALIZED VIEW LOG
          73 DROP MATERIALIZED VIEW  LOG
          74 CREATE MATERIALIZED VIEW
          75 ALTER MATERIALIZED VIEW
          76 DROP MATERIALIZED VIEW
          77 CREATE TYPE
          78 DROP TYPE
          79 ALTER ROLE
          80 ALTER TYPE
          81 CREATE TYPE BODY
          82 ALTER TYPE BODY
          83 DROP TYPE BODY
          84 DROP LIBRARY
          85 TRUNCATE TABLE
          86 TRUNCATE CLUSTER
          87 CREATE BITMAPFILE
          88 ALTER VIEW
          89 DROP BITMAPFILE
          90 SET CONSTRAINTS
          91 CREATE FUNCTION
          92 ALTER FUNCTION
          93 DROP FUNCTION
          94 CREATE PACKAGE
          95 ALTER PACKAGE
          96 DROP PACKAGE
          97 CREATE PACKAGE BODY
          98 ALTER PACKAGE BODY
          99 DROP PACKAGE BODY
         157 CREATE DIRECTORY
         158 DROP DIRECTORY
         159 CREATE LIBRARY
         160 CREATE JAVA
         161 ALTER JAVA
         162 DROP JAVA
         163 CREATE OPERATOR
         164 CREATE INDEXTYPE
         165 DROP INDEXTYPE
         166 ALTER INDEXTYPE
         167 DROP OPERATOR
         168 ASSOCIATE STATISTICS
         169 DISASSOCIATE STATISTICS
         170 CALL