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

部分 VI. Oracle

目錄

62. Oracle 12c 安裝可
62.1. Server 安裝
62.2. Desktop 安裝
62.3. Oracle Net Services Configuration
62.3.1. Listener configuration
62.3.2. Local Net Service Name configuration
62.4. Oracle 12c Client for Windows 10
62.5. 卸載 Oracle
62.6. Linux 安裝 sqlplus
63. Privilege
63.1. Account
63.1.1. show user
63.1.2. DEFAULT_TABLESPACE
63.1.3. unlock/lock
63.2. User
63.2.1. Create user
63.2.2. Drop user
63.2.3. Alter user
63.2.4. 修改密碼
63.2.5. Reset Password 忘記密碼重置密碼
63.3. grant
63.3.1. 列出權限
63.3.2. 查看用戶權限
63.3.3. 吊銷權限
63.3.4. System Privileges 系統權限
63.3.4.1. EM 權限
63.3.4.2. Granting and Revoking SYSDBA and SYSOPER Privileges
63.3.5. Object Privileges 對象權限
63.4. Opening the Encrypted Wallet
64. 資料庫管理
64.1. lsnrctl
64.2. listener.ora
64.3. TNS 配置
64.3.1. HOST
64.3.2. SID
64.4. parameter
64.4.1. db
64.4.2. instance_name
64.4.3. service_name
64.4.4. global_name
64.4.5. db_name
64.4.6. db_domain
64.4.7. sga
64.4.8. size
64.4.9. spfile
64.4.10. cache
64.4.11. Character Set
64.5. 進程
64.6. 查看用戶
64.7. 顯示表
64.8. 顯示試圖
64.9. PROCEDURE
64.10. FUNCTION
64.11. 視圖、存儲過程、函數
64.12. 查看存儲過程原始碼
64.13. 日期時間格式
64.13.1. Date
64.13.2. 修改系統日期格式
64.13.3. TIMESTAMP
64.13.4.
64.14. 切換字符集
64.14.1. 切換到 GBK
64.14.2. 切到 UTF-8
64.14.3. 切到 AL32UTF8
64.14.4. 切換過程實例
64.15. Oracle 表空間
64.15.1. 查詢空閒表空間
64.15.2. 創建表空間
64.15.2.1. 臨時表空間
64.15.3. 更改表空間屬性
64.15.3.1. 修改表空間大小
64.15.4. 刪除表空間
65. Oracle Gui
65.1. Create instance
65.2. Oracle Net Configuration Assistant
65.3. Oracle Enterprise Manager
65.3.1. EM Configuration issue. /opt/oracle/product/11.2.0/dbhome_1/orcl.example.com_orcl not found.
65.4. Other GUI - phpOraAdmin
66. CLI
66.1. SQL*Plus
66.1.1. conn
66.1.2. startup/shutdown
66.1.2.1. startup
66.1.2.2. shutdown
66.1.3. $ORACLE_HOME/sqlplus/admin/glogin.sql
66.1.4. @運行SQL
66.1.5. 連結資料庫
66.2. exp/imp
66.2.1. exp
66.2.2. imp
66.2.2.1. A用戶導出B用戶導入
66.3. expdp/impdp
66.3.1. expdp
66.3.2. impdp
66.3.3. 數據泵演示
66.3.4. 查看dmp檔案的表空間
66.4. RMAN
66.4.1. 資料庫模式
66.4.2. 完全備份
66.4.3. 增量備份
66.4.4. 恢復資料庫
66.4.5. 是用tar打包rman檔案
66.4.6. 打包 rman 備份檔案
67. DDL
67.1. 欄位類型
67.1.1. Date
67.1.2. TIMESTAMP
67.2. 索引
67.3. 表
67.3.1.
67.3.2. 約束檢查
67.4. SEQUENCE 序列
67.4.1.
68. 程序包
68.1. 執行包中的過程
69. 資料庫連結
70. Oracle 監控
70.1. Oracle日誌的路徑
70.2. SQL 日誌監控
70.2.1. 查詢性能分析
70.2.2. IO性能分析
70.3. session
70.4. SQL Monitoring Report
71. Installing Oracle Database
71.1. Installing Oracle Database 10g Release 2 on Linux x86
71.2. 11gR2
71.3. Installing Oracle Client 11g
71.4. Silence Install - Database
71.4.1. Response File
71.4.2. OS 配置腳本
71.4.3. 運行 runInstaller
71.5. Silence Install - Client
71.6. oracle 817 script
71.7. Script for automatic startup on boot
71.8. Run level shell script to start Oracle 10g services on RedHat Enterprise Linux (RHAS 4)
72. FAQ
72.1. Reset root password 重置MySQL root密碼
72.2. 資料庫內容替換
72.3. 查看錯誤代碼
72.3.1. ERROR 1153 (08S01) at line 3168: Got a packet bigger than 'max_allowed_packet' bytes
72.3.2. ERROR 1129 (00000): Host 'XXXXXX' is blocked because of many connection errors; unblock with 'mysqladmin flush-hosts'
72.4. 臨時表是否需要建索引
72.5. Kill 腳本
72.6. ERROR 1503 (HY000): A PRIMARY KEY must include all columns in the table's partitioning function
72.7. ERROR 1820 (HY000): You must reset your password using ALTER USER statement before executing this statement.
72.8. ERROR 1819 (HY000): Your password does not satisfy the current policy requirements
72.9. 重新整理AUTO_INCREMENT欄位
72.10. 轉換 latin1 到 UTF-8
72.11. this is incompatible with sql_mode=only_full_group_by
72.12. [Warning] Changed limits: max_open_files: 5000 (requested 20480)
72.13. ERROR 1364: 1364: Field 'id' doesn't have a default value
72.14. ERROR 1290 (HY000): The MySQL server is running with the --secure-file-priv option so it cannot execute this statement
72.15. ERROR 1086 (HY000): File '/var/lib/mysql-files/order.txt' already exists
72.16. ERROR 1415: Not allowed to return a result set from a trigger