随笔分类 -  Oracle

oracle 使用过程中遇到的种种问题
导出ORACLE数据库的数据字典
摘要：SELECT B.TABLE_NAME AS "表名", C.COMMENTS AS "表说明", B.COLUMN_ID AS "字段序号", B.COLUMN_NAME AS "字段名", B.DATA_TYPE AS "字段数据类型", B.DATA_LENGTH AS "数据长度", B.DATA_PRECISION AS "整数位", B.DATA_SCALE AS "小数位", A.COMMENTS AS "字段说 阅读全文

posted @ 2011-03-14 12:47 jsbrml 阅读(601) 评论(0) 推荐(0)

scott用户对象维护
摘要：SQL@D:\oracle\product\10.2.0\db_1\RDBMS\ADMIN 阅读全文

posted @ 2011-01-28 16:25 jsbrml 阅读(138) 评论(0) 推荐(0)

oracle 942错误（exp imp 出问题的解决方案）
摘要：SQL select comp_id,version from dba_registry;-----------------------------------------------------------------------------------------------------------　　:\Documents and Settings\Administratorsqlplus /nolog　　SQL*Plus: Release 9.2.0.7.0 - ProdUCtion on 星期五 9月 29 12:34:11 2006　　Copyright (c) 1982, 2 阅读全文

posted @ 2010-12-21 10:33 jsbrml 阅读(3820) 评论(1) 推荐(0)

导航