oracle ora-00997 problems
Oracle8i,9i 中對Long 操作有一個限制.就是:
所有的select,Update,lock tables 的所有Long columns 必須在同一個Database中.
而你的SQL,正好選取了兩個long columns 分別在兩個database 上.所以會出現 ora-00997 的錯誤.
[@more@]-----原始郵件-----
發件人: Harrison Jiang
傳送時間: 2005年4月19日 13:11
收件人: Lis Li
主題: all_tab_columnsselect a.column_name,a.data_type,a.data_length,a.nullable,a.data_default,b.data_type,b.data_length,b.nullable,b.data_default
from all_tab_columns a,all_tab_columns@acmtest b
where a.owner = 'BQY'
and b.owner = 'BQY'
and a.table_name = 'MBM'
and b.table_name = 'MBM'
and a.column_name = b.column_name
and ((a.data_type <> b.data_type) or (a.data_length <> b.data_length) or (a.nullable <> b.nullable) or (a.data_default<>b.data_default))
來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/34596/viewspace-796379/,如需轉載,請註明出處,否則將追究法律責任。
相關文章
- oracle ora-00997 problems【Blog 搬家】Oracle
- Oracle Database Link ProblemsOracleDatabase
- Oracle Database Link Problems【Blog 搬家】OracleDatabase
- git - problemsGit
- Week 11 Problems
- Week 4 Problems
- LeetCode Flatten Related ProblemsLeetCode
- Week 8 Problems 幽夜默示錄
- ora-00997 非法使用LONG資料型別資料型別
- ORA-00997: 非法使用 LONG 資料型別資料型別
- java Build Path Problems:Archive for required libraryJavaUIHive
- Row Movement Common Questions and Problems on Partitioned Tables
- Problems with OWB 11.2 on Winsows XP
- 【《TOP》讀書筆記】<1> Performance Problems筆記ORM
- Problems in Mathematical Analysis (American First Edition)
- FAQ: Row Movement Common Questions and Problems on Partitioned Tables
- Common Diagnostic Scripts for AUM problems (Doc ID 746173.1)
- ServeRAID mismatched software levels can result in system problemsServerAI
- What problems does Google Wave solve?(轉載)Go
- 【《TOP》讀書筆記】<3> Identifying Performance Problems筆記IDEORM
- intellij IDEA--- 報inspects a maven model for resolution problemsIntelliJIdeaMaven
- Using OMS DEBUG mode to troubleshoot OEM 12c problems
- android studio新建hello world時出現Rendering ProblemsAndroid
- MongoDB 啟動時關於 NUMA 警告 的分析----(To avoid performance problems)MongoDBORM
- TKDE 2017:A Comprehensive Survey of Graph Embedding: Problems, Techniques and ApplicationsAPP
- 由ORA-00997: illegal use of long datatype引發的血案之long轉換為lob
- 安裝ROS出現 Unable to Correct Problems ‘You have Held Broken Packages’ 錯誤ROSPackage
- 由ORA-00997: illegal use of long datatype引發的血案之long轉換為lob之二
- 【leetcode】高頻題目整理_樹結構篇( High Frequency Problems, Tree )LeetCode
- XML namespace problems with IBM JDK(xml在使用ibm jdk時解釋錯誤)XMLnamespaceIBMJDK
- Bug 5496862 : IO READING PROBLEMS AFTER INSTALLING IBM TECHNOLOGY LEVEL 5IBM
- Android Stdio 中的Rendering Problems Android N requires the IDE to be running with Java 1.8 or later Install a supported JDK解決辦法AndroidUIIDEJavaJDK
- oracle DBLink oracleOracle
- Oracle 中$ORACLE_HOME/bin/oracle檔案Oracle
- oracle 修改ORACLE例項Oracle
- oracle安裝工具目錄常用解釋oracle wallet manager/Oracle Directory Manager /oracle net manager /Oracle Net ManagOracle
- ORACLE基礎之oracle鎖(oracle lock mode)詳解Oracle
- 【Oracle】oracle tablespace&datafile -- oracle表空間 分享[轉]Oracle