- 博客(14)
- 收藏
- 关注
转载 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
387
原创 Oracle SQL turning
exec DBMS_STATS.gather_table_stats(ownname=>'', tabname=>'');
2016-09-13 16:59:12
692
原创 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
340
原创 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
531
原创 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
334
原创 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
274
原创 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
2107
原创 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
2088
原创 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
1894
原创 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
927
原创 Oracle -- Create DB link
CREATE DATABASE LINK LINK_NAME CONNECT TO schema IDENTIFIED BY abc123 USING '';
2016-09-06 16:38:59
222
原创 Oracle -- DBA
select name,log_mode from v$database;-----------PATH: /optware/arch/
2016-09-06 16:35:13
267
原创 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
278
原创 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
608
空空如也
空空如也
TA创建的收藏夹 TA关注的收藏夹
TA关注的人