Home | 简体中文 | 繁体中文 | 杂文 | 打赏(Donations) | 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
73.14. ERROR 1290 (HY000): The MySQL server is running with the --secure-file-priv option so it cannot execute this statement
73.15. ERROR 1086 (HY000): File '/var/lib/mysql-files/order.txt' already exists
73.16. ERROR 1415: Not allowed to return a result set from a trigger