Oracle实用命令资料.doc

Oracle实用命令 Author:HBD Create Date:2012-12-07  TOC \o 1-3 \h \z \u  HYPERLINK \l _Toc342657600 1.1. Oracle实用命令  PAGEREF _Toc342657600 \h 2  HYPERLINK \l _Toc342657601 1.1.1. 测试数据库连接  PAGEREF _Toc342657601 \h 2  HYPERLINK \l _Toc342657602 1.1.2. 启动TNS监听  PAGEREF _Toc342657602 \h 2  HYPERLINK \l _Toc342657603 1.1.3. 查看监听状态  PAGEREF _Toc342657603 \h 2  HYPERLINK \l _Toc342657604 1.1.4. 用户解锁  PAGEREF _Toc342657604 \h 2  HYPERLINK \l _Toc342657605 1.1.5. 远程登录  PAGEREF _Toc342657605 \h 2  HYPERLINK \l _Toc342657606 1.1.6. 创建表空间  PAGEREF _Toc342657606 \h 2  HYPERLINK \l _Toc342657607 1.1.7. 创建用户  PAGEREF _Toc342657607 \h 3  HYPERLINK \l _Toc342657608 1.1.8. 创建表  PAGEREF _Toc342657608 \h 4  HYPERLINK \l _Toc342657609 1.1.9. 增加字段  PAGEREF _Toc342657609 \h 4  HYPERLINK \l _Toc342657610 1.1.10. 修改字段  PAGEREF _Toc342657610 \h 4  HYPERLINK \l _Toc342657611 1.1.11. 删除字段  PAGEREF _Toc342657611 \h 4  HYPERLINK \l _Toc342657612 1.1.12. 修改字段名  PAGEREF _Toc342657612 \h 4  HYPERLINK \l _Toc342657613 1.1.13. 修改表名  PAGEREF _Toc342657613 \h 4  HYPERLINK \l _Toc342657614 1.1.14. 查看表结构  PAGEREF _Toc342657614 \h 5  HYPERLINK \l _Toc342657615 1.1.15. 拷贝表数据  PAGEREF _Toc342657615 \h 5  HYPERLINK \l _Toc342657616 1.2. Oracle导入导出  PAGEREF _Toc342657616 \h 5  HYPERLINK \l _Toc342657617 1.2.1. Oracle导出数据  PAGEREF _Toc342657617 \h 5  HYPERLINK \l _Toc342657618 1.2.2. Oracle导入数据  PAGEREF _Toc342657618 \h 5  HYPERLINK \l _Toc342657619 1.2.3. Oracle11G导出10G的数据  PAGEREF _Toc342657619 \h 6  HYPERLINK \l _Toc342657620 1.2.4. 常见问题  PAGEREF _Toc342657620 \h 7  HYPERLINK \l _Toc342657621 1.3. Oracle自动备份  PAGEREF _Toc342657621 \h 7  HYPERLINK \l _Toc342657622 1.3.1. 批处理的编写  PAGEREF _Toc342657622 \h 7  HYPERLINK \l _Toc342657623 1.3.2. 配置计划任务  PAGEREF _Toc342657623 \h 8  HYPERLINK \l _Toc342657624 1.4. Oracle网络配置  PAGEREF _Toc342657624 \h 19  HYPERLINK \l _