oracle查询表结构.doc

首页资讯精华论坛问答博客群组更多您还未登录 !我的应用登录注册2010-10-18缩略显示oracle查询表结构博客分类： 数据库-oracle方法1-按照表明查询select * from ALL_TAB_COLS Awhere lower(A.Table_Name) = vw_all_res_search_view方法2-按照用户查询，当前用户下面的所有表结构select b.TABLE_NAME as 表名, ments 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 小数位, ments as 字段说明 from all_col_comments a, all_tab_columns b,all_tab_comments cwhere a.owner = BICP and a.owner = b.OWNER And a.table_name = b.TABLE_NAME and a.column_name = b.COLUMN_NAME And c.table_name = a.table_name and c.owner = a.ownerorder by a.table_name, b.COLUMN_ID 16:50 评论/ 浏览 (0 / 778) 分类:数据库2010-07-31缩略显示Oracle错误一览表（3）博客分类： 数据库-oracleORA-09751: pw_attachPorts: 服务器调用 pws_attach 失败ORA-09752: pw_attachPorts: port_allocate 失败ORA-09753: spwat: 无效的进程号ORA-09754: sppst: 传送给 sppst 的进程号无效ORA-09755: osngpn: 端口配置失败ORA-09756: osnpns: 名服务器中没有端口ORA-09757: osnipn: 端口配置失败ORA-09758: osnipn: 无法检查名服务器中的端口ORA-09759: osnsbt: 收到的信息错误ORA-09760: osnpui: 无法发送中断信息ORA-09761: pw_destroyPorts: 服务器调用 pws_stop_instance 失败ORA-09762: sNeXT_instanceName: 转换错误ORA-09763: osnmpx: 交换 Mach 端口时出现发送/接收错误ORA-09764: osnmop: oracle 可执行（代码）访问错误ORA-09765: osnmop: 分叉失败ORA-09766: osnmop: 缓冲区分配失败ORA-09767: osnmfs: msg_send 的返回代码错误ORA-09768: osnmgetmsg: 无法读信息ORA-09769: osnmbr: 无法发送中断信息ORA-09770: pws_look_up: 转换失败ORA-09771: osnmwrtbrkmsg: msg_send 的返回代码错误ORA-09772: osnpmetbrkmsg: 来自主机的信息类型错误ORA-09773: osnmgetdatmsg: 来自主机的信息类型错误ORA-09774: osnmui: 无法发送中断信息ORA-09775: osnmrs: 重置协议错误ORA-09776: pws_look_up: (Oracle 帮助程序) 可执行 (代码) 访问错误ORA-09777: osnpbr: 无法发送中断信息ORA-09778: snynfyport: 无法配置通知端口ORA-09779: snyGetPort: 无法分配端口ORA-09786: sllfop: 打开错误，无法打开文件ORA-09787: sllfop: 不可识别的处理选项，格式错误ORA-09788: sllfrb: 无法读文件ORA-09789: sllfsk: 无法读文件ORA-09790: sllfcf: 无法关闭文件ORA-09791: slembdf: 转换错误，无法转换错误文件名ORA-09792: sllfop: 无法分配读缓冲区ORA-09793: szguns: 用户名的长度大于缓冲区的长度ORA-09794: szrbuild: 角色名的长度大于缓冲区的长度ORA-09795: szrbuild: 无法 malloc 角色结构ORA-09796: szrbuild: 无法 malloc 角色名ORA-09797: 无法获得 O/S MAC 权限ORA-09798: 标记比较失败ORA-09799: 文件标记检索失败ORA-09800: 进程阅读权限标记检索失败。ORA-09801: 无法获得来自连接的用户 IDORA-09802: 无法转换二进制标记为字符串ORA-09803: 无法分配字符串缓冲区ORA-09804: 从二进制到 ORACLE 的类转换失败ORA-09805: 无法转换类别编号为字符串ORA-09806: 无法分配标记字符串缓冲区ORA-09807: 从字符串到二进制的标记转换失败ORA-09808: 无法获得用户清除ORA-09809: 无法从连接获得用户组 IDORA-09810: 无法从连接获得进程 IDORA-09811: 无法初始化程序包ORA-09812: 无法从连接获得用户清除ORA-09813: 无法获得目录状态ORA-09814: 无法扩展文件名ORA-09815: 文件名缓冲区溢出ORA-09816: 无法设置有效权限ORA-09817: 无法写入审计文件ORA-09818: 数字过大ORA-09819: 数字超出最大合法值ORA-09820: 无法转换类字符串为数字表示法ORA-09821: 数字标记无效ORA-09822: 无法转换审计文件名ORA-09823: 设备名过长ORA-09824: 无法启用 allowmacaccess 权限ORA-09825: 无法禁用 allowmacaccess 权限ORA-09826: SCLIN: 无法初始化原子锁栓ORA-09827: sclgt: 原子锁栓返回未知的错误ORA-09828: SCLFR: 原子锁栓返回错误ORA-09829: pw_createPorts: 服务器调用 pws_start_instance 失败ORA-09830: snyAddPort: 无法执行远程过程调用ORA-09831: snyStartThread: 无法建立服务器端口设置ORA-09832: infoCallback: 信息格式错误ORA-09833: addCallback: 信息格式错误ORA-09834: snyGetPortSet: 无法获得端口信息ORA-09835: addCallback: 回调端口已经设置ORA-09836: addCallback: 无法添加端口到回调设置ORA-09837: addCallback: 无法添加分配到回调链接ORA-09838: removeCallback: 无法删除回调端口ORA-09839: removeCallback: 回调端口不在回调设置中ORA-09840: soacon: 名称转换失败ORA-09841: soacon: 名称转换失败ORA-09842: soacon: Archmon 无法创建指定管道ORA-09843: soacon: Archmon 无法创建命名管道ORA-09844: soacon: Archmon 无法打开命名管道ORA-09845: soacon: Archmon 无法打开命名管道ORA-09846: soacon: ARCH 无法打开命名管道ORA-09847: soacon: ARCH 无法打开命名管道ORA-09848: soawrt: 无法写入命名管道ORA-09849: soarcv: 无法从命名管道读取ORA-09850: soacon: Archmon 无法锁定命名管道ORA-09851: soacon: Archmon 无法锁定命名管道ORA-09853: snyRemovePort: 从请求返回的代码错误ORA-09854: snyPortInfo: 从请求返回的代码错误ORA-09855: removeCallback: 信息格式错误ORA-09856: smpalo: 在分配 pga 时出现 vm_allocate 错误ORA-09857: smprset: 在保护 pga 时出现 vm_protect 错误ORA-09870: spini: 无法初始化最大数的打开文件ORA-09871: TASDEF_NAME: 扩展?/dbs/tasdef.dbf时出现转换错误ORA-09872: TASDEF_CREATE: 无法创建?/dbs/tasdef.dbfORA-09873: TASDEF_OPEN: 打开tasdef.dbf文件时出现打开错误ORA-09874: TASDEF_READ: 读错误，无法读tasdef.dbf文件ORA-09875: TASDEF_WRITE: 在写?/dbs/tasdef.dbf文件时出现写错误ORA-09876: TASDEF_CLOSE: 无法关闭?/dbs/tasdef.dbf文件ORA-09877: sstascre: shmget 错误，无法获得共享内存段ORA-09878: sstascre/sstasat: shmat 错误，无法连接 tas 写入页ORA-09879: sstascre/sstasat: shmat 错误，无法连接 tas 读取页ORA-09880: sstasfre/sstasdel: shmdt 错误，无法分离写入页ORA-09881: sstasfre/sstasdel: shmdt 错误，无法分离读取页ORA-09882: sstasfre/sstasdel: shmctl 错误，无法删除 tas shm 页ORA-09883: 双工接口: oratab 文件不存在ORA-09884: 双工接口: SID 没有配置当前 PUORA-09885: osnTXtt: 无法创建 TXIPC 通道ORA-09886: osnTXtt: 在扩展txipc.trc时出现转换错误ORA-09887: osnTXtt: 无法创建/打开调试通道ORA-09888: osnTXtt: 无法创建 txipc 通道ORA-09889: osnTXtt: oracle 可执行 (代码) 访问错误ORA-09890: osnTXtt: malloc 失败ORA-09908: slkmnm: gethostname 返回错误代码ORA-09909: 无法 Malloc 暂存缓冲区ORA-09910: 无法找到用户的 ORACLE 口令文件条目ORA-09911: 用户口令错误ORA-09912: 无法 Malloc 名称缓冲区ORA-09913: 无法 Malloc 转储名ORA-09914: 无法打开 ORACLE 口令文件ORA-09915: 口令加密失败ORA-09916: 未指定要求的口令ORA-09918: 无法从 SQL*Net 获得用户权限ORA-09919: 无法设置专用服务器的标记ORA-09920: 无法从连接获得阅读权限标记ORA-09921: 无法从连接获得信息标记ORA-09922: 无法生成进程 - 未正确创建背景日志目录ORA-09923: 无法生成进程 - 未正确创建用户日志目录ORA-09924: 无法生成进程 - 未正确创建磁心转储目录ORA-09925: 无法创建审计线索文件ORA-09926: 无法设置服务器的有效权限集ORA-09927: 无法设置服务器标记ORA-09928: 无法恢复服务器标记ORA-09929: 两个标记的 GLB 无效ORA-09930: 两个标记的 LUB 无效ORA-09931: 无法打开要读取的 ORACLE 口令文件ORA-09932: 无法关闭 ORACLE 口令文件ORA-09933: 无法删除旧的口令文件ORA-09934: 无法将当前口令文件链接到旧文件ORA-09935: 无法撤消链接当前口令文件ORA-09936: 无法打开要写入的 ORACLE 口令文件ORA-09937: ORACLE 口令文件的 Chmod 失败ORA-09938: 无法保存信号处理程序ORA-09939: 无法恢复信号处理程序ORA-09940: ORACLE 口令文件标题损坏ORA-09941: orapasswd 或安装程序的版本比文件更旧ORA-09942: ORACLE 口令文件标题写失败ORA-09943: 无法分配口令列表组件的内存ORA-09944: 口令条目损坏ORA-09945: 无法初始化审计线索文件ORA-09946: 缓冲区的文件名过长ORA-09947: 无法配置连接属性结构ORA-09948: 无法检索进程信息标记ORA-09949: 无法获得客户操作系统权限ORA-09950: 无法获得服务器操作系统权限ORA-09951: 无法创建文件ORA-09952: scgcmn: lk_open_convert 返回未预期的值: 无法打开ORA-09953: scggc: 锁定转换时返回未预期的值ORA-09954: scgcc: 回调锁定关闭时返回未预期的状态ORA-09955: scgcan: 取消锁定时返回未预期的状态ORA-09956: scgcm: 未预期的锁定状态条件ORA-09957: 无法发送结束请求到 IMONORA-09958: IMON: 具有相同 ORACLE pid 的两个进程处于活动状态ORA-09959: IMON: 无法删除进程ORA-09960: 无法建立终止信号的信号处理程序ORA-09961: 无法恢复终止信号处理程序ORA-09962: scggrc 中的 lk_group_create 错误ORA-09963: scggra 中的 lk_group_attach 错误ORA-09964: scggrd 中的 lk_group_detach 错误ORA-09966: scumnt: 在扩展 ?/dbs/lk 时出现转换错误ORA-09967: scumnt: 无法创建或打开文件ORA-09968: scumnt: 无法锁定文件ORA-09969: scurls: 无法关闭锁定文件ORA-09974: skxfidini: 初始化 SDI 通道时出错ORA-09975: kxfspini: 初始化 SDI 进程时出错ORA-09976: skxfqdini: 创建端口时出错ORA-09977: skxfqhini: 连接时出错ORA-09978: skxfqhdel: 从另一终端断开连接时出错ORA-09979: skxfqhsnd: 发送信息到另一终端时出错ORA-09980: skxfqdrcv: 从另一终端接收信息时出错ORA-09981: skxfqdreg: 添加页到 SDI 缓冲池时出错ORA-09982: skxfqddrg: 从 SDI 缓冲池删除页时出错ORA-09983: skxfidsht: 关闭 SDI 通道时出错ORA-09985: 无法读取 SGA 定义文件ORA-09986: 从 SGA 定义文件读取的字节数错误ORA-09987: 在 READ-ONLY 模式下无法连接到 SGAORA-09988: 分离 SGA 时出错ORA-09989: 尝试使用无效的 skgmsdef 结构指针ORA-10000: controlfile debug event, name control_fileORA-10001: controlfile crash event1ORA-10002: controlfile crash event2ORA-10003: controlfile crash event3ORA-10004: controlfile crash event4ORA-10005: trace latch operations for debuggingORA-10006: testing - block recovery forcedORA-10008: log switch debug crash after new log header write, threadORA-10009: log switch debug crash after old log header write, threadORA-10010: Begin TransactionORA-10011: End TransactionORA-10012: Abort TransactionORA-10013: Instance RecoveryORA-10014: Roll Back to Save PointORA-10015: Undo Segment RecoveryORA-10016: Undo Segment extendORA-10017: Undo Segment WrapORA-10018: Data Segment CreateORA-10019: Data Segment RecoveryORA-10020: partial link restored to linked list (KSG)ORA-10021: latch cleanup for state objects (KSS)ORA-10022: trace ktsgspORA-10023: Create Save Undo SegmentORA-10024: Write to Save UndoORA-10025: Extend Save Undo SegmentORA-10026: Apply Save UndoORA-10027: latch cleanup for enqueue locks (KSQ)ORA-10028: latch cleanup for enqueue resources (KSQ)ORA-10029: session logon (KSU)ORA-10030: session logoff (KSU)ORA-10031: sort debug event (S*)ORA-10032: sort statistics (SOR*)ORA-10033: sort run information (SRD*/SRS*)ORA-10035: parse SQL statement (OPIPRS)ORA-10036: create remote row source (QKANET)ORA-10037: allocate remote row source (QKARWS)ORA-10038: dump row source tree (QBADRV)ORA-10039: type checking (OPITCA)ORA-10040: dirty cache listORA-10041: dump undo records skippedORA-10042: trap error during undo applicationORA-10043: check consistency of owner/waiter/converter lists in KSQORA-10044: free list undo operationsORA-10045: free list update operations - ktsrsp, ktsunlORA-10046: enable SQL statement timingORA-10047: trace switching of sessionsORA-10048: Undo segment shrinkORA-10049: protect library cache memory heapsORA-10050: sniper traceORA-10051: trace OPI callsORA-10052: dont clean up obj$ORA-10053: CBO Enable optimizer traceORA-10054: trace UNDO handling in MLSORA-10055: trace UNDO handingORA-10056: dump analyze stats (kdg)ORA-10057: suppress file names in error messagesORA-10058: use table scan cost in tab$.spare1ORA-10059: simulate error in logfile create/clearORA-10060: CBO Enable predicate dumpORA-10061: disable SMON from cleaning temp segmentORA-10062: disable usage of OS Roles in osdsORA-10063: disable usage of DBA and OPER privileges in osdsORA-10064: thread enable debug crash level , threadORA-10065: limit library cache dump information for state object dumpORA-10066: simulate failure to verify fileORA-10067: force redo log checksum errors - block numberORA-10068: force redo log checksum errors - file numberORA-10069: Trusted Oracle test eventORA-10070: force datafile checksum errors - block numberORA-10071: force datafile checksum errors - file numberORA-10072: protect latch recovery memoryORA-10073: have PMON dump info before latch cleanupORA-10074: default trace function mask for kstORA-10076: CBO Enable cartesian product join costingORA-10078: CBO Disable constant predicate elimination optimizationORA-10079: trace data sent/received via SQL*NetORA-10080: dump a block on a segment list which cannot be exchangedORA-10081: segment High Water Mark has been advancedORA-10083: a brand new block has been requested from space managementORA-10084: free list becomes emptyORA-10085: free lists have been mergedORA-10087: disable repair of media corrupt data blocksORA-10088: CBO Disable new NOT IN optimizationORA-10089: CBO Disable index sortingORA-10090: invoke other events before crash recoveryORA-10091: CBO Disable constant predicate mergingORA-10092: CBO Disable hash joinORA-10093: CBO Enable force hash joinsORA-10094: before resizing a data fileORA-10095: dump debugger commands to trace fileORA-10096: after the cross instance call when resizing a data fileORA-10097: after generating redo when resizing a data fileORA-10101: atomic redo write recoveryORA-10102: switch off anti-joinsORA-10103: CBO Disable hash join swappingORA-10104: dump hash join statistics to trace fileORA-10106: CBO Disable evaluating correlation pred last for NOT INORA-10107: CBO Always use bitmap indexORA-10108: CBO Dont use bitmap indexORA-10109: CBO Disable move of negated predicatesORA-10110: CBO Try index rowid range scansORA-10111: Bitmap index creation switchORA-10112: Bitmap index creation switchORA-10113: Bitmap index creation switchORA-10114: Bitmap index creation switchORA-10115: CBO Bitmap optimization use maximal expressionORA-10116: CBO Bitmap optimization switchORA-10117: CBO Disable new parallel cost modelORA-10118: CBO Enable hash join costingORA-10119: QKA Disable GBY sort eliminationORA-10120: generate relative file # different from absoluteORA-10121: CBO Dont sort bitmap chainsORA-10122: Disable transformation of count(col) to count(*)ORA-10123: QKA Disable Bitmap And-EQualsORA-10125: Disable remote sort eliminationORA-10126: Debug oracle java xaORA-10127: Disable remote query block operationORA-10128: Dump Partition Pruning InformationORA-10129: Alter histogram lookup for remote queriesORA-10130: sort disable readaheadsORA-10131: use v$sql_plan code path for explain planORA-10132: dump plan after compilationORA-10133: testing for SQL Memory ManagementORA-10134: tracing for SQL Memory Management for sessionORA-10135: CBO do not count 0 rows partitionsORA-10136: CBO turn off fix for bug 1089848ORA-10137: CBO turn off fix for bug 1344111ORA-10138: CBO turn off fix for bug 1577003ORA-10139: CBO turn off fix for bug 1386119ORA-10140: CBO turn off fix for bug 1332980ORA-10141: CBO disable additional keys for inlist in bitmap optimizationORA-10142: CBO turn off advanced OR-expansion checksORA-10143: CBO turn off hintsORA-10144: CBO turn off cost based selection of bji over bsj subqueryORA-10145: test auditing network errorsORA-10146: enable Oracle TRACE collectionORA-10147: enable join push through UNION viewORA-10148: Use pre-7.3.3 random generatorORA-10149: allow the creation of constraints with illegal date constantsORA-10150: import exceptionsORA-10151: Force duplicate dependency removalORA-10152: CBO dont consider function costs in plansORA-10153: Switch to use public synonym if private one does not translateORA-10154: Switch to disallow synonyms in DDL statementsORA-10155: CBO disable generation of transitive OR-chainsORA-10156: CBO disable index fast full scanORA-10157: CBO disable index access path for in-listORA-10158: CBO preserve predicate order in post-filtersORA-10159: CBO disable order-by sort pushdown into domain indexesORA-10160: CBO disable use of join indexORA-10161: CBO recursive semi-join on/off-switchORA-10162: CBO join-back elimination on/off-switchORA-10163: CBO join-back elimination on/off-switchORA-10164: CBO disable subquery-adjusted cardinality fixORA-10166: trace long operation statistics updatesORA-10167: CBO use old index MIN/MAX optimizationORA-10168: CBO disable single-table predicate predicate generationORA-10169: CBO disable histograms for multi partitionsORA-10170: CBO use old bitmap costingORA-10171: CBO disable transitive join predicatesORA-10172: CBO force hash join backORA-10173: CBO no constraint-based join-back eliminationORA-10174: view join-back elimination switchORA-10175: CBO star transformation switchORA-10176: CBO colocated join switchORA-10177: CBO colocated join switchORA-10179: CBO turn off transitive predicate replacementORA-10180: temp table transformation print error messagesORA-10181: CBO disable multi-column in-list processingORA-10182: CBO disable generation of implied predicatesORA-10183: CBO disable cost roundingORA-10185: CBO force index joinsORA-10186: CBO disable index joinORA-10187: CBO additional index join switchORA-10188: CBO additional index join switchORA-10189: CBO turn off FFS null fixORA-10190: Analyze use old frequency histogram collection and densityORA-10192: nopushdown when number of groups exceed number of rowsORA-10193: Force repeatable sampling with specified seedORA-10194: CBO disable new LIKE selectivity heuristicORA-10195: CBO dont use check constraints for transitive predicatesORA-10196: CBO disable index skip scanORA-10197: CBO force index skip scanORA-10198: check undo recordORA-10199: set parameter in sessionORA-10200: consistent read buffer statusORA-10201: consistent read undo applicationORA-10202: consistent read block headerORA-10203: block cleanoutORA-10204: signal recursive extendORA-10205: row cache debuggingORA-10206: transaction table consistent readORA-10207: consistent read transactions status reportORA-10208: consistent read loop checkORA-10209: enable simulated error on controlfileORA-10210: check data block integrityORA-10211: check index block integrityORA-10212: check cluster integrityORA-10213: crash after controlfile writeORA-10214: simulate write errors on controlfileORA-10215: simulate read errors on controlfileORA-10216: dump controlfile headerORA-10217: debug sequence numbersORA-10218: dump uba of applied undoORA-10219: monitor multi-pass row lockingORA-10220: show updates to the transaction tableORA-10221: show changes done with undoORA-10222: row cacheORA-10223: transaction layer - turn on verification codesORA-10224: index block split/delete traceORA-10225: free/used extent row cacheORA-10227: verify (multi-piece) row structureORA-10228: trace application of redo by kcocbkORA-10229: simulate I/O error against datafilesORA-10230: check redo generation by copying before applyingORA-10231: skip corrupted blocks on _table_scans_ORA-10233: skip corrupted blocks on index operationsORA-10235: check memory manager internal structuresORA-10236: library cache managerORA-10237: simulate C (for testing purposes)ORA-10238: instantiation managerORA-10239: multi-instance library cache managerORA-10240: dump dbas of blocks that we wait forORA-10241: remote SQL execution tracing/validationORA-10242: suppress OER 2063 (for testing distrib w/o different error log)ORA-10244: make tranids in error msgs print as 0.0.0 (for testing)ORA-10245: simulate lock conflict error for testing PMONORA-10246: print trace of PMON actions to trace fileORA-10247: Turn on scgcmn tracing. (VMS ONLY)ORA-10248: turn on tracing for dispatchersORA-10249: turn on tracing for multi-stated serversORA-10250: Trace all allocate and free calls to the topmost SGA heapORA-1025