Home | 簡體中文 | 繁體中文 | 雜文 | 打賞(Donations) | ITEYE 博客 | OSChina 博客 | Facebook | Linkedin | 知乎專欄 | Search | About

部分 VI. Oracle

目錄

63. Oracle 12c 安裝可
63.1. Server 安裝
63.2. Desktop 安裝
63.3. Oracle Net Services Configuration
63.3.1. Listener configuration
63.3.2. Local Net Service Name configuration
63.4. Oracle 12c Client for Windows 10
63.5. 卸載 Oracle
63.6. Linux 安裝 sqlplus
64. Privilege
64.1. Account
64.1.1. show user
64.1.2. DEFAULT_TABLESPACE
64.1.3. unlock/lock
64.2. User
64.2.1. Create user
64.2.2. Drop user
64.2.3. Alter user
64.2.4. 修改密碼
64.2.5. Reset Password 忘記密碼重置密碼
64.3. grant
64.3.1. 列出權限
64.3.2. 查看用戶權限
64.3.3. 吊銷權限
64.3.4. System Privileges 系統權限
64.3.4.1. EM 權限
64.3.4.2. Granting and Revoking SYSDBA and SYSOPER Privileges
64.3.5. Object Privileges 對象權限
64.4. Opening the Encrypted Wallet
65. 資料庫管理
65.1. lsnrctl
65.2. listener.ora
65.3. TNS 配置
65.3.1. HOST
65.3.2. SID
65.4. parameter
65.4.1. db
65.4.2. instance_name
65.4.3. service_name
65.4.4. global_name
65.4.5. db_name
65.4.6. db_domain
65.4.7. sga
65.4.8. size
65.4.9. spfile
65.4.10. cache
65.4.11. Character Set
65.5. 進程
65.6. 查看用戶
65.7. 顯示表
65.8. 顯示試圖
65.9. PROCEDURE
65.10. FUNCTION
65.11. 視圖、存儲過程、函數
65.12. 查看存儲過程原始碼
65.13. 日期時間格式
65.13.1. Date
65.13.2. 修改系統日期格式
65.13.3. TIMESTAMP
65.13.4.
65.14. 切換字符集
65.14.1. 切換到 GBK
65.14.2. 切到 UTF-8
65.14.3. 切到 AL32UTF8
65.14.4. 切換過程實例
65.15. Oracle 表空間
65.15.1. 查詢空閒表空間
65.15.2. 創建表空間
65.15.2.1. 臨時表空間
65.15.3. 更改表空間屬性
65.15.3.1. 修改表空間大小
65.15.4. 刪除表空間
66. Oracle Gui
66.1. Create instance
66.2. Oracle Net Configuration Assistant
66.3. Oracle Enterprise Manager
66.3.1. EM Configuration issue. /opt/oracle/product/11.2.0/dbhome_1/orcl.example.com_orcl not found.
66.4. Other GUI - phpOraAdmin
67. CLI
67.1. SQL*Plus
67.1.1. conn
67.1.2. startup/shutdown
67.1.2.1. startup
67.1.2.2. shutdown
67.1.3. $ORACLE_HOME/sqlplus/admin/glogin.sql
67.1.4. @運行SQL
67.1.5. 連結資料庫
67.2. exp/imp
67.2.1. exp
67.2.2. imp
67.2.2.1. A用戶導出B用戶導入
67.3. expdp/impdp
67.3.1. expdp
67.3.2. impdp
67.3.3. 數據泵演示
67.3.4. 查看dmp檔案的表空間
67.4. RMAN
67.4.1. 資料庫模式
67.4.2. 完全備份
67.4.3. 增量備份
67.4.4. 恢復資料庫
67.4.5. 是用tar打包rman檔案
67.4.6. 打包 rman 備份檔案
68. DDL
68.1. 欄位類型
68.1.1. Date
68.1.2. TIMESTAMP
68.2. 索引
68.3. 表
68.3.1.
68.3.2. 約束檢查
68.4. SEQUENCE 序列
68.4.1.
69. 程序包
69.1. 執行包中的過程
70. 資料庫連結
71. Oracle 監控
71.1. Oracle日誌的路徑
71.2. SQL 日誌監控
71.2.1. 查詢性能分析
71.2.2. IO性能分析
71.3. session
71.4. SQL Monitoring Report
72. Installing Oracle Database
72.1. Installing Oracle Database 10g Release 2 on Linux x86
72.2. 11gR2
72.3. Installing Oracle Client 11g
72.4. Silence Install - Database
72.4.1. Response File
72.4.2. OS 配置腳本
72.4.3. 運行 runInstaller
72.5. Silence Install - Client
72.6. oracle 817 script
72.7. Script for automatic startup on boot
72.8. Run level shell script to start Oracle 10g services on RedHat Enterprise Linux (RHAS 4)
73. FAQ
73.1. Reset root password 重置MySQL root密碼
73.2. 資料庫內容替換
73.3. 查看錯誤代碼
73.3.1. ERROR 1153 (08S01) at line 3168: Got a packet bigger than 'max_allowed_packet' bytes
73.3.2. ERROR 1129 (00000): Host 'XXXXXX' is blocked because of many connection errors; unblock with 'mysqladmin flush-hosts'
73.4. 臨時表是否需要建索引
73.5. Kill 腳本
73.6. ERROR 1503 (HY000): A PRIMARY KEY must include all columns in the table's partitioning function
73.7. ERROR 1820 (HY000): You must reset your password using ALTER USER statement before executing this statement.
73.8. ERROR 1819 (HY000): Your password does not satisfy the current policy requirements
73.9. 重新整理AUTO_INCREMENT欄位
73.10. 轉換 latin1 到 UTF-8
73.11. this is incompatible with sql_mode=only_full_group_by
73.12. [Warning] Changed limits: max_open_files: 5000 (requested 20480)
73.13. ERROR 1364: 1364: Field 'id' doesn't have a default value