Fanny_Zheng-优快云博客

转载 Oracle -- Set NS_NCHAR_CHARACTEREST

--------------------1 change NLS_NCHAR_CHARACTERSET SHUTDOWN IMMEDIATE; STARTUP MOUNT exclusive RESTRICT;ALTER SYSTEM ENABLE RESTRICTED SESSION; ALTER SYSTEM SET JOB_QUEUE_PROCESSES=0; A

2016-09-13 17:00:51 466

原创 Oracle SQL turning

exec DBMS_STATS.gather_table_stats(ownname=>'', tabname=>'');

2016-09-13 16:59:12 759

原创 ORA-28001: The password has expired

---ORA-28001: The password has expired1.Connect as sysdba to the database. C:\Users\Siry>sqlplus / as sysdba2.Run the query to set the password’s life time to unlimited. SQL> ALTER PROFILE DEF

2016-09-13 16:58:29 406

原创 Cognos tree prompt automatic search function

1) add html tag "json2.js", input json2.js source file, can download from google.2) upload json file to server, the search function will search data from json file3) add html tag "JsonDat

2016-09-06 17:04:29 596

原创 Oracle -- SQL tunning privilege

---sql tuninggrant advisor to ;grant administer sql tuning set to ;--CHECK CURRENT DB SETselect b.tablespace_name, tbs_size SizeMb, a.free_space FreeMb from (select tablespace_name, r

2016-09-06 16:52:46 399

原创 Oracle -- SQL monitor privilege

---sql mornintor grant select on v_$sqltext_with_newlines to ;grant select on v_$session to ;grant select on v_$locked_object to ;grant select on v_$lock to ;

2016-09-06 16:51:45 326

原创 Oracle add temp file

select TABLESPACE_NAME, BYTES_USED/1024/1024/1024 as GB_USED , BYTES_FREE/1024/1024/1024 GB_FREE from V$TEMP_SPACE_HEADER;ALTER TABLESPACE TEMP ADD TEMPFILE '/u20/oradata/CCIRPAT/DATAFILES/temp

2016-09-06 16:49:09 2267

原创 Oracle -- ORA-09817 ORA-09945

Enter user-name: /as sysdbaERROR:ORA-09817: Write to audit file failed.Linux-x86_64 Error: 28: No space left on deviceAdditional information: 12ORA-09945: Unable to initialize the audit trai

2016-09-06 16:43:54 2248

原创 Oracle ORA-00604

--ORA-00604: error occurred at recursive SQL level 1--ORA-01654: unable to extend index SYS.I_PLSCOPE_SIG_ACTION$ by 128 in tablespace SYSAUX--00604. 00000 - "error occurred at recursive SQL

2016-09-06 16:42:55 2018

原创 Oracle -- Grant privilege

CREATE TABLE "GRANT_PRIVS_INFO" ( "GRANT_REVOKE" VARCHAR2(1000 BYTE), "PRIVS" VARCHAR2(100 BYTE), "TABLE_NAME" VARCHAR2(64 BYTE), "GRANTEE" VARCHAR2(100 BYTE) ) ;create or re

2016-09-06 16:40:15 999

原创 Oracle -- Create DB link

CREATE DATABASE LINK LINK_NAME CONNECT TO schema IDENTIFIED BY abc123 USING '';

2016-09-06 16:38:59 274

原创 Oracle -- DBA

select name,log_mode from v$database;-----------PATH: /optware/arch/

2016-09-06 16:35:13 322

原创 Oracle transfer parent child tree to json

---TREE transfor to JASON WITH connect_by_query as ( select ROWNUM as rnum , ORG_ENTITY_ID ,ORG_ENTITY_NAME ,PARENT_ORG_ENTITY_ID,HIRARCHY_LEVEL as Lvlfrom MS_FLOWDOWN_TMP

2016-09-06 16:31:31 332

原创 Oracle --- Create instance

pbrun - rootsu - oracle1. Create all required directories as below.mkdir -p /u20/oracle/admin/PROJECT/adumpmkdir -p /u20/oracle/admin/PROJECT/dpdumpmkdir -p /u20/oracle/admin/PROJECT/p

2016-09-06 16:18:13 691

Effie_Zheng的博客