基本情報データベースシステムのコンセプトソフトウェア情報SAP DB および MaxDB文書デモデータベーススキーマ HOTEL のオブジェクトダウンロードバージョン表記サポートされているオペレーティングシステムとアーキテクチャデータベースソフトウェアのオープンソース開発サポートWeb PTS による問題メッセージの追跡データベースシステムの概要SQLトランザクションデータ変更のログ記録履歴管理例: 再実行例: 整合性のあるビューデータベースオブジェクトのロック共有ロック排他ロックオプティミスティックロック現象並列ロック分離レベルデータの保管ワークメモリ領域ボリューム (永続記憶域)セーブポイント論理アクセス構造LONG 列のあるテーブルの B* ツリー索引付テーブルの B* ツリー再バランシング例: SELECT 文例: INSERT 文例: DELETE 文例: UPDATE 文コンバータデータベースツールインタフェーステクニカルシステムランドスケープネットワーク通信データベースツールのアーキテクチャインタフェースのアーキテクチャデータ暗号化例: MaxDB データベースインスタンスがあるシステムランドスケープ例: MaxDB データベースインスタンスが 2 つある SAP システムランドプロセス構造プロセスの概要サービスの概要タスクの概要タスクステータスの概要タスク切替負荷分散特別スレッドの概要データベースインスタンスの登録および設定データベースインスタンスの計画技術的制約データベースインスタンスのテンプレートデータベース名の規則データベースパラメータ共通データベースパラメータ特殊データベースパラメータサポートデータベースパラメータliveCache データベースパラメータデータベースパラメータのプロパティ自動起動例: データベースインスタンスの起動スクリプト (Linux)ログ設定設定ファイルデータベース設計データベース設計のヒント管理定期管理タスク管理タスクの自動化データベースイベントカテゴリの概要ユーザ、認証、および権限データベースシステム管理者 (SYSDBA ユーザ)データベースマネージャオペレータ (DBM オペレータ)データベースユーザDBM サーバのサーバ権限ユーザ名とパラメータの規則認証特別オペレーティングシステムユーザおよびグループ (UNIX/Linux)<sdb_user> (特別オペレーティングシステムユーザ)<sdba_group> (特別オペレーティングシステムグループ)サポートグループ (特別オペレーティングシステムグループ)バックアップとリストアバックアップテンプレートとデータキャリアさまざまなデータキャリアタイプに関する注意事項データのバックアップログエントリのバックアップバックアップファイルのアーカイブデータベースインスタンスのリストア例: バックアップとリストアリモートコンピュータによるデータのバックアップとリストア他のプロバイダのバックアップツールの使用データ領域の凍結 (スナップショット)エクスポートとインポートレプリケーションと高可用性データベースコピーデータベースコピーの互換性のあるプロセッサアーキテクチャ待機データベース待機インスタンスの設定待機インスタンスの更新有効なインスタンスとしての待機インスタンスの起動ホットスタンバイホットスタンバイシステムのシステム要件ホットスタンバイシステムのアーキテクチャマスタインスタンスと待機インスタンスの同期エラー発生時のホットスタンバイシステムの動作同期化監視パフォーマンスパフォーマンスボトルネックの分析SQL 文の自動変換SQL オプティマイザSQL オプティマイザの動作方法検索条件等価条件範囲条件IN 条件LIKE 条件UPDATE 文の制約コスト決定SQL オプティマイザ統計検索方針順次検索キー列の検索条件索引列の検索条件OR を使用してリンクされた検索条件FETCH 時間への検索の延期結合JOIN_SEARCH_LEVEL データベースパラメータすべての検索方針の一覧CATALOG KEY ACCESSCATALOG SCANCATALOG SCAN USING USER EQUAL CONDITIONDIFFERENT STRATEGIES FOR OR TERMSEQUAL CONDITION FOR INDEXEQUAL CONDITION FOR KEYIN CONDITION FOR INDEXIN CONDITION FOR KEYINDEX SCANJOIN VIA INDEXED COLUMNJOIN VIA KEY COLUMNJOIN VIA KEY RANGEJOIN VIA MULTIPLE INDEXED COLUMNSJOIN VIA MULTIPLE KEY COLUMNSJOIN VIA RANGE OF MULTIPLE INDEXED COL.JOIN VIA RANGE OF MULTIPLE KEY COLUMNSNO RESULT SET POSSIBLENO STRATEGY NOW (ONLY AT EXECUTION TIME)RANGE CONDITION FOR INDEXRANGE CONDITION FOR KEYSUBQ CONDITION FOR INDEXSUBQ CONDITION FOR KEYTABLE SCANトラブルシューティングEXPLAIN 文結合の EXPLAIN 文複雑な SELECT 文の EXPLAIN 文サブクエリがある SELECT 文の EXPLAIN 文STRATEGY 列トラブルシューティング典型的なエラー状況ログファイルトレースデータベース構造のチェックデータ構造でのエラーの修正例: データ構造でのエラーデータベースアプリケーションの開発用語集A管理変更後イメージアプリケーションデータアーキテクチャASCII認証権限AUTOCOMMIT モード自動ログバックアップ自動開始自動化BB* ツリーBackint for MaxDBバックアップバックアップファイルバックアップ履歴バックアップ IDバックアップ媒体バックアップテンプレートバックアップツールバックアップタイプ変更前イメージBLOBCCacheカタログキャッシュCheckpointCLOBコード属性列コマンドモードコマンドモニタCOMMIT通信サーバ完全データバックアップコンポーネントグループ設定設定ディレクトリ設定ファイル整合性のあるビュー制約制御構造コンバータコストクリティカルセクションカーソルDデータアクセスデータ領域データバックアップデータキャッシュデータキャリアデータ完全性データレコードデータ型データボリュームデータライタデータベースデータベース管理者 (DBA ユーザ)データベースアナライザデータベースアプリケーションデータベースカタログデータベース接続データベースコピーデータベース設計データベースファイルデータベース機能データベース IDデータベースインスタンスデータベースマネージャデータベースマネージャオペレータ (DBM オペレータ)データベース名データベースオブジェクトデータベースパラメータデータベースプロシージャデータベースセッションデータベース構造データベースシステムデータベースシステム管理者 (SYSDBA ユーザ)データベースツールデータベーストレースデータベースユーザDBADBA 計画カレンダDBADMINDBM コマンドDBM オペレータDBM オペレータプロパティDBM オプションDBM サーバDBMCLIDBMGUIDDL 文デフォルトパラメータファイルデモデータベース開発ディレクトリ構造文書文書内の変数ドメインダウンロードE暗号化環境変数エラーメッセージイベントイベントディスパッチャ例排他ロック実行計画EXPLAIN 文エクスポート外部バックアップツールFFBM (空きブロック管理)ファイルクラスファイルディレクトリファイル ID外部キーGガーベッジコレクタH高可用性履歴ファイルヒット率同機種間のシステムコピーホットスタンバイII/O バッファキャッシュインポート増分データバックアップIndex索引列初期化インストールインストールマネージャインストールプロファイル対話式ログバックアップInterface内部データベースファイル倒置一覧反転列分離レベルJJavaJDBC結合KカーネルカーネルログカーネルバリアントキーワードKNLDIAGL言語サポート (MapChar セット)リーフページliveCache (SAP liveCache テクノロジー)負荷分散ローダローダサーバロード中LOBロックロック一覧ログ領域ログバックアップログエントリログファイルログモードログページログキューログリーダログセグメントログ設定ログボリュームログライタロギングLONG 値MメーリングリストMapchar セットマスタインスタンスMaxDBマージメッセージサーバ移行監視マルチプロセッサの設定N命名規則ネットワークOODBCOLTP (MaxDB)OMSOMS ヒープOMS バージョンオープンソース開発オペレーティングシステムユーザ操作モード動作状態オプティミスティックロックオプティマイザログ領域の上書きモード所有者Pページページチェーンページャ並列バックアップパラメータパラメータファイルSQL 文のパラメータパフォーマンスPerlPHPポートプリコンパイラ述語準備された文一次キー特権プロセスプログラミングインタフェースPTS (問題追跡システム)PythonQクエリツールRローデバイスリーダ/ライタロックREDO 一覧REDO ログエントリREDO ログファイルREDO ログ管理REDO ログマネージャREDO タスク地域再編成レプリケーションレプリケーションテーブルレプリケーション単位予約語RESOURCE ユーザリソースモニタ再実行再起動情報リストア制約ロールROLL FORWARDROLLBACK行実行ディレクトリSSAP DBセーブポイントスケジューラスキーマスクリプトモードsdbsdba検索方針二次キー選択度区切記号順序シーケンスキャッシュサーバ権限サーバタスクServiceサービスデータベースインスタンスサービスセッションセッションモード共有ロック共有メモリ共有 SQLスナップショットソフトウェアコンポーネント特別スレッドSQLSQL モードSQL オプティマイザSQL セッションSQL 文SQL StudioSQL チュートリアルSQLCLISQLDBCSSL/TLSSTANDARD ユーザ待機データベーススタンバイインスタンスStart統計ストアドプロシージャ方針サブトランザクションサポート同期化同期マネージャ同期ユーザシノニム構文表記SYSDBA ユーザシステム停止システムコピーシステム要件システムテーブルシステムトリガTテーブルテーブル IDテーブル名タスクタスクステータスデータベースインスタンスのテンプレートスレッドタイムアウトタイマタスクツールトレーストレースライタタスクトランザクショントランザクションファイルトランザクション一覧トリガトラブルシューティングチュートリアルUUNDO ログエントリUNDO ログファイルユニコードアンロード更新アップグレードUserユーザグループユーザカーネルスレッドユーザキーユーザタスクユーザ定義関数ユーティリティタスクV変数バージョンビュービューテーブル仮想コンピュータVMAKEボリュームvservervtraceWWeb DBMWeb サーバWeb サーバマネージャWeb SQLWeb ツールWebDAVワークメモリXX ServerXCONS (データベースコンソール)XUSERYZ
Documentation Not Available in Japan.SQL Reference ManualData definitionEnsuring Data IntegrityCREATE TABLE Statement (create_table_statement)Column Definition (column_definition)Data Type (data_type)CHAR[ACTER]VARCHARLONG[VARCHAR]Code AttributeBOOLEANFIXEDFLOATINT[EGER]SMALLINTDATE (Date Value)TIME (Time Value)TIMESTAMP (Time Stamp Value)NULL ValueSpecial NULL valueNumberCharacter StringColumn Attributes (column_attributes)Memory Requirements of a Column Value According to Data TypeCONSTRAINT Definition (constraint_definition)Referential CONSTRAINT Definition (referential_constraint_definiKey definitionUNIQUE Definition (unique_definition)DROP TABLE statementALTER TABLE Statement (alter_table_statement)ADD Definition (add_definition)ALTER Definition (alter_definition)COLUMN Change Definition (column_change_definition)DROP definitionMODIFY Definition (modify_definition)RENAME TABLE statementRENAME COLUMN Statement (rename_column_statement)EXISTS TABLE Statement (exists_table_statement)CREATE SCHEMA Statement (create_schema_statement)RENAME SCHEMA Statement (rename_schema_statement)DROP SCHEMA Statement (drop_schema_statement)CREATE DOMAIN Statement (create_domain_statement)DROP DOMAIN Statement (drop_domain_statement)CREATE SEQUENCE Statement (create_sequence_statement)DROP SEQUENCE statement)CREATE SYNONYM Statement (create_synonym_statement)DROP SYNONYM Statement (drop_synonym_statement)RENAME SYNONYM Statement (rename_synonym_statement)CREATE VIEW Statement (create_view_statement)INSERT/UPDATE/DELETE Privilege for Owners of View TablesUpdateable Join View TableDROP VIEW Statement (drop_view_statement)RENAME VIEW Statement (rename_view_statement)CREATE INDEX Statement (create_index_statement)DROP INDEX statementALTER INDEX Statement (alter_index_statement)RENAME INDEX Statement (rename_index_statement)CREATE DBPROC[EDURE] Statement (create_dbproc_statement)Routine (routine)General CASE Statement (searched_case_statement)Simple CASE Statement (simple_case_statement)DROP DBPROC[EDURE] Statement (drop_dbproc_statement)CREATE SYSTEM TRIGGER Statement (create_system_trigger_statementDROP SYSTEM TRIGGER Statement (drop_system_trigger_statement)CREATE FUNCTION Statement (create_function_statement)DROP FUNCTION Statement (drop_function_statement)CREATE TRIGGER Statement (create_trigger_statement)DROP TRIGGER statementCOMMENT ON Statement (comment_on_statement)AuthorizationCREATE USER Statement (create_user_statement)CREATE USERGROUP Statement (create_usergroup_statement)DROP USER Statement (drop_user_statement)DROP USERGROUP Statement (drop_usergroup_statement)ALTER USER Statement (alter_user_statement)ALTER USER GROUP Statement (alter_usergroup_statement)RENAME USER statementRENAME USERGROUP Statement (rename_usergroup_statement)GRANT USER Statement (grant_user_statement)GRANT USERGROUP Statement (grant_usergroup_statement)ALTER PASSWORD StatementCREATE ROLE statementDROP ROLE statementGRANT StatementREVOKE Statement (revoke_statement)Data ManipulationINSERT Statement (insert_statement)Data Type of the Target Column and Inserted ValueJoin View Table, QUERY Expression, CONSTRAINT Definition, TriggeUPDATE Statement (update_statement)DELETE Statement (delete_statement)NEXT STAMP Statement (next_stamp_statement)CALL statementData queryQUERY Statement (query_statement)DECLARE CURSOR statement (declare_cursor_statement)Recursive DECLARE CURSOR StatementSELECT Statement (select_statement)QUERY Expression (query_expression)Table Expression (table_expression)Subquery (subquery)ORDER Clause (order_clause)UPDATE Clause (update_clause)LOCK Option (lock_option)FETCH Statement (fetch_statement)CLOSE Statement (close_statement)SINGLE SELECT statement (single_select_statement)EXPLAIN Statement (explain_statement)TransactionsCONNECT Statement (connect_statement)SET Statement (set_statement)COMMIT Statement (commit_statement)ROLLBACK Statement (rollback_statement)SUBTRANS Statement (subtrans_statement)INNER TRANSACTION Statement (inner_transaction_statement)SQL SAVEPOINT Statements (savepoint/rollback_to_/release_savepoiLOCK Statement (lock_statement)UNLOCK Statement (unlock_statement)RELEASE Statement (release_statement)StatisticsUPDATE STATISTICS Statement (update_statistics_statement)MONITOR statementSQL Statements: OverviewComment (sql_comment)Frequently Used Syntax Elements: OverviewCASCADE Option (cascade_option)CharacterColumn Specification (column spec)DEFAULT Specification (default_spec)DELETE Rule (delete_rule)DISTINCT function (distinct spec)DUPLICATES Clause (duplicates_clause)ExpressionSpecifications of Values (extended_value_spec)Function (function spec)Arithmetic Function (arithmetic_function)ABS(a)CEIL(a)EXP(a)FIXED(a,p,s)FLOAT(a,s)FLOOR(a)INDEX(a,b,p,s)LENGTH(a)LN(a)LOG(a,b)NOROUND(a)PIPOWER(a,n)ROUND(a,n)SIGN(a)SQRT(a)TRUNC(a,n)Conversion Function (conversion_function)CHAR(a,t)CHR(a,n)HEX(a)HEXTORAW(a)NUM(a)Date and Time Format (datetimeformat)Date functionADDDATE/SUBDATE(t,a)DATEDIFF(t,s)DAYNAME/MONTHNAME(t)DAYOFWEEK/WEEKOFYEAR/DAYOFMONTH/DAYOFYEAR(t)MAKEDATE(a,b)Database Function Call (dbfunction_call)Extraction functionDATE(a)HOUR/MINUTE/SECOND(t)MICROSECOND(a)TIME(a)TIMESTAMP(a,b)YEAR/MONTH/DAY(t)Special Function (special_function)DECODE(x,y(i),...,z)GREATEST/LEAST(x,y,...)VALUE(x,y,...)General CASE Function (searched_case_function)Simple CASE Function (simple_case_function)String Function (string_function)ALPHA(x,n)ASCII(x)EXPAND(x,n)GET_OBJECTNAME(x,o)GET_SCHEMA(x,o)INITCAP(x)LFILL(x,a,n)LPAD(x,a,y,n)LTRIM(x,y)MAPCHAR(x,n,i)REPLACE(x,y,z)RFILL(x,a,n)RPAD(x,a,y,n)RTRIM(x,y)SOUNDEX(x)SUBSTR(x,a,b)TRANSLATE(x,y,z)TRIM(x,y)UPPER/LOWER(x)ConcatenationTime Function (time_function)ADDTIME/SUBTIME(t,a)MAKETIME(h,m,s)TIMEDIFF(t,s)Trigonometric Function (trigonometric_function)Joined Table (joined_table)Key Specification (key_spec)LiteralFixed Point Number (fixed_point_literal)Floating Point Number (floating_point_literal)Unsigned integer (unsigned_integer)IntegerParameter Specification (parameter spec)PredicateBETWEEN predicateBoolean Predicate (bool_predicate)Comparison Predicate (comparison_predicate)DEFAULT Predicate (default predicate)EXISTS predicateIN predicateJOIN Predicate (join_predicate)LIKE Predicate (like_predicate)NULL predicateQuantified predicateROWNO Predicate (rowno_predicate)SOUNDS Predicate (sounds_predicate)SAMPLE Definition (sample_definition)Search Condition (search_condition)Selected Column (select_column)Set Function (set_function_spec)Character Set (token)IdentifierKeyword (key_word)Functions: OverviewNames: OverviewAlias Name (alias_name)Column Name (column_name)Constraint Name (constraint_name)Name of a Database Function (dbfunction_name)Name of a database procedure (dbproc_name)Domain Name (domain_name)Index Name (index_name)Indicator Name (indicator_name)MapChar Set Name (mapchar_set_name)PasswordParameter Name (parameter_name)Reference Name (reference_name)Name of a Referential Constraint (referential_constraint_name)Results Table Name (result_table_name)Role Name (role_name)Schema Name (schema_name)Sequence Name (sequence_name)Synonym Name (synonym_name)Table Name (table_name)Trigger Name (trigger_name)User Group Name (usergroup_name)User Name (user_name)Privileges: OverviewPrivilege Specification (priv_spec)Privilege Specification for a Schema (schema_priv_spec)Syntax Listadd_definitionalias_nameall_functionalter_definitionalter_index_statementalter_password_statementalter_table_statementalter_user_statementalter_usergroup_statementargumentargument1arithmetic_functionASCII_or_UNICODEassignment_statementbetween_predicatebool_predicateboolean_factorboolean_termcall_statementcascade_optioncase_else_clausecase_functioncase_statementcharactercheck_expressionclose_statementcolumn_attributescolumn_change_definitioncolumn_definitioncolumn_listcolumn_namecolumn_speccommentcomment_on_statementcommit_statementcomp_opcomparison_predicateconnect_modeconnect_optionconnect_statementconstraint_definitionconstraint_nameconversion_functioncreate_dbproc_statementcreate_domain_statementcreate_function_statementcreate_index_statementcreate_role_statementcreate_schema_statementcreate_sequence_statementcreate_synonym_statementcreate_system_trigger_statementcreate_table_statementcreate_table_tempcreate_trigger_statementcreate_user_statementcreate_usergroup_statementcreate_view_statementdata_typedate_functiondate_or_timestamp_expressiondatetimeformatdbfunction_calldbfunction_namedbproc_namedeclare_cursor_statementdefault_expressiondefault_predicatedefault_specdelete_ruledelete_statementdelimiter_tokenderived_columndigitdigit_sequencedistinct_functiondistinct_specdomain_namedouble_quotesdrop_dbproc_statementdrop_definitiondrop_domain_statementdrop_function_statementdrop_index_statementdrop_role_statementdrop_schema_statementdrop_sequence_statementdrop_synonym_statementdrop_system_trigger_statementdrop_table_statementdrop_table_tempdrop_trigger_statementdrop_user_statementdrop_usergroup_statementdrop_view_statementduplicates_clauseequal_or_notexists_predicateexists_table_statementexplain_statementexponentexpressionexpression_listextended_expressionextended_letterextended_value_specextraction_functionfactorfetch_statementfinal_selectfirst_characterfirst_password_characterfixed_point_literalfloating_point_literalformal_parameterformal_parameter1from_clausefrom_table_specfunction_specgrant_statementgrant_user_statementgrant_usergroup_statementgranted_usergroupsgranted_usersgranteegroup_clausehaving_clausehex_digithex_digit_seqhex_literalhoursidentifieridentifier_tail_characterif_statementin_predicateindex_column_nameindex_nameindex_specindicator_nameinitial_selectinner_transaction_statementinsert_expressioninsert_statementintegerINTERNAL_ANSI_DB2_ORACLEjoin_predicatejoin_specjoined_tablekey_definitionkey_or_not_null_speckey_speckey_wordlanguage_specific_characterletterlike_expressionlike_predicatelimit_clauseliterallocal_variablelocal_variable_listlocal_variableslock_optionlock_speclock_statementmantissamapchar_set_namematch_charmatch_setmatch_stringminutesmodify_column_definitionmodify_definitionmonitor_statementnew_index_namenew_passwordnew_schema_namenew_synonym_namenew_table_namenew_user_namenew_usergroup_namenext_stamp_statementnot_reserved_key_wordnull_predicatenumeric_literalobject_specoffsetold_index_nameold_passwordold_synonym_nameold_table_nameorder_clauseouter_join_indicatorparameter_nameparameter_specpasswordpattern_elementpositionpredicatepriv_specprivilegequantified_predicatequantifierquery_expressionquery_primaryquery_specquery_statementquery_termrecursive_declare_cursor_statementrecursive_selectreference_namereferenced_columnreferenced_tablereferencing_columnreferential_constraint_definitionreferential_constraint_nameregular_tokenrelease_savepoint_statementrelease_statementrename_column_statementrename_index_statementrename_schema_statementrename_synonym_statementrename_table_statementrename_user_statementrename_usergroup_statementrename_view_statementreserved_key_wordresult_column_nameresult_expressionresult_table_namerevoke_statementrole_namerollback_statementrollback_to_statementroutineroutine_sql_statementrow_countrow_specrowno_columnrowno_predicatesample_definitionsavepoint_statementscalar_subqueryschema_authorization_identifierschema_elementschema_nameschema_name_clauseschema_priv_specschema_privilegesearch_and_result_specsearch_conditionsearch_expressionsearched_case_functionsearched_case_statementsearched_case_when_clausesecondsselect_columnselect_statementsequence_nameset_function_nameset_function_specset_insert_clauseset_statementset_update_clausesignsimple_case_functionsimple_case_statementsimple_case_when_clausesimple_identifiersingle_select_statementsort_specsound_predicatesource_userspecial_characterspecial_functionspecial_identifierspecial_identifier_charactersql_commentsql_comment_textsql_savepoint_namesql_statementstamp_columnstatementstatement_liststring_functionstring_literalstring_specsubquerysubtrans_statementsynonym_nametable_columnstable_description_elementtable_expressiontable_nametermtime_expressiontime_or_timestamp_expressiontime_functiontokentop_spectrigger_eventtrigger_nametrigonometric_functionunderscoreunique_definitionunlock_statementunsigned_integerupdate_clauseupdate_statementupdate_statistics_statementuser_modeuser_nameusergroup_modeusergroup_namevalue_specvariable_namevertical_slashwhere_clausewhile_statementSyntax NotationSyntax Changesシステムテーブル一般注記データベース用語システムテーブルの評価 (例)ACTIVECONFIGURATIONCACHESTATISTICSCOLUMNSCONSTRAINTSDATASTATISTICSDATAVOLUMESDBPROCEDURESDBPROCPARAMSDOMAINCONSTRAINTSDOMAINSFOREIGNKEYCOLUMNSFOREIGNKEYSFUNCTIONSINDEXCOLUMNSINDEXESINSTANCELOCKSLOGQUEUESTATISTICSLOGSTATISTICSMAPCHARSETSROLEPRIVILEGESROLESSEQUENCESSESSION_ROLESSESSIONSSYNONYMSTABLEPRIVILEGESTABLESTRIGGERSUSERSVERSIONVIEWCOLUMNSVIEWDEFSVIEWSシステムテーブルの定義ACTIVECONFIGURATIONBACKUPTHREADSCACHESTATISTICSCATALOGCACHESTATISTICSCLASSCONTAINER_CHAINSCLASSCONTAINER_KEYSCLASSCONTAINER_ROOTSCLASSCONTAINERSCODEPAGECOLUMNSCOMMANDCACHESTATISTICSCOMMANDCACHESTATISTICSRESETCOMMANDSTATISTICSCOMMANDSTATISTICSRESETCONNECTEDUSERSCONNECTPARAMETERSCONSISTENTVIEWSCONSTRAINTCOLUMNSCONSTRAINTSDATACACHEDATASTATISTICSDATASTATISTICSRESETDATAVOLUMESDBPARAMETERSDBPROCEDURESDBPROCPARAMSDOMAINCONSTRAINTSDOMAINSFILEDIRECTORIESFILESFOREIGNKEYCOLUMNSFOREIGNKEYSFUNCTIONSGARBAGECOLLECTOR_STATISTICSHISTORYINFOHOTSTANDBYCOMPONENTHOTSTANDBYGROUPINDEXCOLUMNSINDEXESINDEXSIZEINDEXSTATISTICSINDEXSTORAGEDETAILSINSTANCEIOBUFFERCACHESIOTHREADSTATISTICSIOTHREADSTATISTICSRESETLOCKLISTSTATISTICSLOCKSLOCK_WAITSLOGINFORMATIONLOGQUEUESTATISTICSLOGQUEUESTATISTICSRESETLOGSTATISTICSLOGSTATISTICSRESETLOGVOLUMESMACHINECONFIGURATIONMACHINEUTILIZATIONMAPCHARSETSMEMORYALLOCATORSTATISTICSMONITORMONITOR_CACHESMONITOR_LOADMONITOR_LOCKMONITOR_LOGMONITOR_LONGMONITOR_OMSMONITOR_PAGESMONITOR_REWRITEMONITOR_ROWMONITOR_TRANSOBJECTLOCKSOMS_HEAP_STATISTICSOMS_LOCKOBJ_INFOOMSLOCKSOMS_VERSIONSOPTIMIZERINFORMATIONOPTIMIZERSTATISTICSPACKAGESPOSTUPGRADECHECKLISTREADERWRITERLOCKINFORMATIONREADERWRITERLOCKSTATISTICSREADERWRITERLOCKSTATISTICSRESETREADERWRITERLOCKWAITINGTASKSREGIONINFORMATIONREGIONSTATISTICSREGIONSTATISTICSRESETRESTARTINFORMATIONROLEPRIVILEGESROLESSCHEMAPRIVILEGESSCHEMASSCHEMASIZESEQUENCEPRIVILEGESSEQUENCESSERVERDBSTATISTICSSERVERTASKSSESSION_ROLESSESSIONSSNAPSHOTSSPINLOCKPOOLSTATISTICSSPINLOCKPOOLSTATISTICSRESETSPINLOCKSTATISTICSSPINLOCKSTATISTICSRESETSYNONYMSSYSTEMTRIGGERSSYSUPDATECOUNTERWANTEDSYSUPDSTATWANTEDSYSUPGRADEHISTORYTABLEPRIVILEGESTABLESTABLESIZETABLESTATISTICSTABLESTORAGEDETAILSTASKGROUPSTATISTICSTASKGROUPSTATISTICSRESETTASKLOADBALANCINGINFORMATIONTASKLOADBALANCINGTASKGROUPSTATESTASKLOADBALANCINGTASKMOVESTRANSACTIONHISTORYTRANSACTIONSTRANSACTIONSTRANSFORMATIONMODELTRANSFORMATIONMONITORTRANSFORMATIONPACKAGESTRANSFORMATIONRESOURCESTRANSFORMATIONSTATISTICSTRANSFORMATIONSTEPSTRIGGERSUNLOADEDSTATEMENTSUSERSUSERSTATISTICSVERSIONVERSIONSVIEWCOLUMNSVIEWDEFSVIEWSVIEWTABLESRestrictions for SQL StatementsORACLE SQL モードSQL 構文エレメントデータベースオブジェクト名称名称領域オブジェクトへのアクセス整数番号設定データ型擬似列演算子機能書式SQL 文alter_cluster_statementalter_database_statementalter_function_statementalter_index_statementalter_package_statementalter_procedure_statementalter_profile_statementalter_resource_cost_statementalter_role_statementalter_rollback_segment_statementalter_sequence_statementalter_snapshot_statementalter_snapshot_log_statementalter_system_statementalter_table_statementalter_tablespace_statementalter_trigger_statementalter_user_statementalter_view_statementanalyze_statementaudit_statementcommit_statementconstraint_clausecreate_cluster_statementcreate_controlfile_statementcreate_database_statementcreate_database_link_statementcreate_index_statementcreate_package_statementcreate_package_body_statementcreate_procedure_statementcreate_profile_statementcreate_rollback_segment_statementcreate_sequence_statementcreate_snapshot_statementcreate_snapshot_log_statementcreate_synonym_statementcreate_table_statementcreate_tablespace_statementcreate_trigger_statementcreate_user_statementcreate_view_statementdeclare_statementdeclare_table_statementdelete_statementdescribe_statementdrop_cluster_statementdrop_database_link_statementdrop_index_statementdrop_procedure_statementdrop_profile_statementdrop_rollback_segment_statementdrop_snapshot_statementdrop_snapshot_log_statementdrop_table_statementdrop_tablespace_statementdrop_trigger_statementdrop_view_statementexecute_statementexplain_plan_statementgrant_statementinsert_statement (埋込 SQL)lock_table_statementnoaudit_statementrename_statementrevoke_statementrollback_statementselect_statementset_transaction_statementtruncate_statementupdate_statementシステムテーブルエラーメッセージメッセージ番号範囲-1 〜 -699-1: Duplicate key in index-8: Execution failed, parse again-20: Duplicate key-25: Duplicate secondary key-30: Integrity violation-32: View violation-35: Referential integrity violated-36: Foreign key integrity violation-40: Lock collision-50: Lock request timeout-51: Lock request timeout-54: Lock collision-60: Work rolled back-65: Work rolled back-70: Session inactivity timeout (Work rolled back)-71: Session terminated by shutdown (Work rolled back)-75: Too many SQL statements (Work rolled back)-101: SQL statement not available in this DB mode-102: SQL statement canceled-103: SQL statement not available for this application-104: DBM command impossible at this time-106: Table unloaded or content deleted-107: SQL statement not allowed for this instance-108: Table or index dropped or content deleted-111: Incompatible incremental backup-115: Table is read only-123: No more log to save-126: Data backup missing (backup history lost)-127: Log backup is not possible because log writing has been sw-128: Log backup is not possible because the log overwrite mode-530: Referential integrity violated-602: System error-900 〜 -999-900: Data area full-901: Log full-902: I/O error-903: Hostfile I/O error-904: Space for result tables exhausted-907: Space for user session exhausted-910: COSTLIMIT for this user exhausted-911: Work rolled back-913: Lock request timeout-914: New volume not accessible-915: No more memory-917: Save/restore write process crash - I/O error-918: Stack overflow-942: Unknown table name-955: Duplicate name-1000 〜 -1999-1000: Too many lock requests-1001: Too many lock objects specified-1002: Too many columns-1003: Too many buffers requested-1004: Too many correlated columns-1005: Too many monadic operators-1006: Too many variables-1007: Parameter list too long-1008: Too many or too few host variables for output-1009: Too many named indexes for this table-1010: Too many volumes-1011: Too many correlated tables-1012: Too many referential constraint definitions for this tabl-1013: Too many order columns-1014: Too many source tables-1015: Too many values-1017: Too many joins-1023: Too many nested subtransactions-1025: Too many asynchron requests-1026: Too many differences between old and new view definition-1102: Too complicated SQL statement (Too many subqueries)-1103: Too complicated SQL statement-1104: Too complicated SQL statement (KB-stack overflow)-1105: Too complicated SQL statement (Too much data)-1106: Too complicated SQL statement (Too much strategy data)-1107: Too complicated SQL statement (Too many internal commands-1108: Too complicated SQL statement (correlated row too long)-1110: View definition too long-1111: Too many savepoints-1112: Constraint too complicated-1113: Too many nested function calls-1114: Communication packet too small-1115: Too many intern columns-1116: Too long trigger parameters-1117: Too complicated trigger qualification-1119: Too many constraints for this table-1120: Too many statements in definition-1200: Too few values-1201: Too few columns-1400: Input parameter cannot be NULL value-1402: Integrity violation-1403: Row not found説明:-1406: Output value truncated-1452: Duplicate secondary key-1556: Data space full-1755: SQL statement will drop further objects (use CASCADE)-2000 〜 -2999-2000: Row too long-2001: Key too long-2002: One output column too long-2003: Output columns too long-2004: Numeric constant too long-2008: Data area too small-2009: Join columns too long-2010: Assignment impossible, char value too long-2012: View column list too long-2013: Select column list too long-2014: Identifier too long-2020: Data buffer too small-2025: Invalid number of backup devices-2027: Space for converted value too small-2028: Sequence <sequence name> exhausted-2029: <sequence_name>.CURRVAL is not yet defined in this sessio-3000 〜 -3999-3000: Invalid host file content-3002: Invalid datatype-3003: Invalid user name-3004: Invalid host file sequence-3005: Invalid SQL statement-3007: Invalid sequence for DML and DDL statements-3008: Invalid keyword or missing delimiter-3009: Invalid table name-3011: Invalid column name-3014: Invalid end of SQL statement-3016: Invalid numeric constant-3017: Invalid unsigned integer-3018: Invalid numeric parameter-3019: Invalid exponent-3020: Invalid length for this data type-3021: Invalid mixture of functions and columns-3022: Invalid number of tables for outer join-3024: Invalid numeric expression-3030: Invalid SESSION TIMEOUT-3035: Invalid date time format-3037: Invalid volume name-3038: Invalid volume size-3046: Invalid char position in string function-3047: Invalid table for RESTORE CATALOG-3048: Invalid date format-3049: Invalid time format-3050: Invalid timestamp format-3054: Invalid block size-3059: Invalid day of week-3060: Invalid escape sequence-3061: Invalid escape value-3062: Invalid month-3063: Invalid format code-3064: Date input value out of range-3065: Invalid date input value-3066: Date input value inconsistent-3067: Invalid timezone-3068: Mismatch of parameter configuration between backup and in-3069: Bad xparam page in backup-3102: Invalid subtrans structure-3103: Invalid sequence definition-3995: Invalid pattern-3998: Wrong password-3999: Invalid parameter-4000 〜 -4999-4000: Unknown result table-4001: Unknown user name/password combination in operational sta-4002: Unknown password-4003: Unknown user name-4004: Unknown table name-4005: Unknown column name-4006: Unknown domain name-4007: Unknown synonym name-4008: Unknown user name/password combination-4009: Unknown referential constraint name-4010: Unknown MAPCHAR SET name-4011: Unknown index name-4013: Unknown user group name-4014: Unknown SERVERDB name-4016: Unknown procedure name-4017: Unknown constraint-4018: Unknown default-4019: Unknown trigger name-4020: Unknown sequence name-4023: Unknown function name-4024: Unknown name-4025: Unknown or not loaded character set-4027: Unknown session-4030: Unknown schema-5000 〜 -5999-5001: Missing privilege-5003: Missing key specification-5004: Missing constant-5005: Missing non-NULL value-5006: Missing identifier-5007: Missing numeric constant-5008: Missing string constant-5009: Missing integer-5010: Missing value specification-5012: Missing definite table name-5013: Missing update column-5014: Missing definite column name-5015: Missing keyword-5016: Missing delimiter-6000 〜 -6999-6000: Duplicate table name-6001: Duplicate column name-6002: Duplicate privilege-6003: Duplicate result table name-6006: Duplicate name-6008: Duplicate index name-6009: Duplicate reference name-6011: Duplicate constraint-6012: Duplicate default-6013: Duplicate trigger definition-6014: Duplicate value-6016: Duplicate format code-7000 〜 -7999-7002: KEY not allowed-7003: NOT NULL not allowed-7004: DEFAULT not allowed-7005: Lower bound greater than upper bound not allowed-7006: Reserved identifier not allowed-7007: Key column not allowed-7008: Updates of this table not allowed-7009: NULL value in key column not allowed-7011: Correlated subquery not allowed-7012: More than one update row not allowed-7015: More than one result row not allowed-7016: Parameter spec not allowed in this context-7017: User not allowed-7018: Variable not allowed in view definition-7019: Feature not allowed in view definition-7021: View column derived from function not allowed-7022: Columns from more than one table not allowed-7023: Dropping of all columns not allowed-7024: Alter column not allowed, constraint violation-7026: SQL statement not allowed without previous FETCH-7029: Function not allowed for this data type-7032: SQL statement not allowed for column of data type LONG-7035: DEFAULT specification not allowed for this column-7036: ROWNO- specification not allowed in this context-7037: NULL value for NOT NULL column not allowed-7038: Foreign key column not allowed-7039: Cycle in referential constraint definition not allowed-7040: Referential constraint not allowed-7041: Result table name not allowed-7042: Key update not allowed-7043: Group member not allowed-7045: Parameter spec not allowed-7046: Column with length greater than 254 not allowed-7048: DROP/ALTER USER not allowed while user is connected-7050: Fastload with indexed table not allowed-7051: Read only view WITH CHECK OPTION not allowed-7055: Column(s) already indexed-7056: Subquery not allowed-7057: View definition contradicts new table definition-7058: Correlated subquery with select in from clause not allowe-7061: LOCK ROW for this table not allowed-7063: Temp table not allowed-7064: Feature not allowed in temp table definition-7065: SUBTRANS COMMIT/ROLLBACK not allowed without SUBTRANS BEG-7066: Unique index referenced by foreign key not allowed-7067: Update without repeated read not allowed-7068: Outer Join not allowed in this context-7071: AUTOSAVE LOG must be stopped-7072: More than one column with default SERIAL not allowed-7074: Cycle in granted roles not allowed-7075: Current save skipped, next is ready to take on this tape-7076: No more data to read from tape-7077: Synonym not allowed-7078: No backup is running-7079: A backup is already running-7080: Query in statement not allowed-7082: SQL statement not allowed for this table type-7084: Parameter change not allowed-7085: Function not allowed for this cursor-7086: Schema not allowed-7500: DCOM HRESULT-7900: Different block sizes-8000 〜 -9799-8000: SERVERDB must be restarted-8001: User must be connected-8002: User already connected to this user task-8003: Log and data must be compatible-8004: Constant must be compatible with column type and length-8005: Value expression must be parameter name-8006: Data types must be compatible-8007: Column must be key column-8009: DEFAULT value must be in constraint specification-8010: Table name must be in from list-8013: Order column must be output column-8014: Result table must be FOR REUSE-8015: Table must be a base table-8016: Table must be a view table-8017: Column must be group column-8018: Index name must be unique-8020: Next volume required-8021: Column must have DEFAULT specification-8022: User already connected-8023: COSTLIMIT must be greater than COSTWARNING-8024: RESTORE CATALOG failed-8025: Table must be temp table-8026: Connect disabled for this user-8028: UNION columns must be compatible-8030: Column must be indexed-8031: Schema must be specified-8033: Incomplete log segment-8034: Order column must be number-8035: Foreign key must exist-8037: DB procedure must be recompiled-8040: Key does not exist-8044: Conversion for character set value impossible-8045: Conversion to UNICODE impossible-8046: Conversion from UNICODE impossible-8047: Password required-8048: Version of component must be compatible with kernel versi-8049: Prepare migration required-8050: Migration error-8051: No snapshot available-8052: Trigger dropped during migration; check view migrationerr-8053: Software version is too old for version of persistent dat-8888: SERVERDB not accessible-9000:SYSTEM ERROR: NOT YET IMPLEMENTED-9001 〜 -9799: System error-10000 〜 -10999-10001: System error: <description>-10003: Feature not supported for kernel version <version>-10100: Invalid value for option <option> of SQLDBC_ConnectPrope-10101: Invalid value for ISOLATIONLEVEL (<description>)-10102: Invalid value for PACKETCOUNT (<description>)-10103: Invalid value for STATEMENTCACHESIZE (<description>)-10104: Invalid value for KEY-10200: Function sequence error (data for execution expected)-10201: Function sequence error (no data for execution expected)-10202: Function sequence error (operation was aborted by discon-10210: Invalid command state (no prepared SQL command)-10220: Calling addBatch is not allowed for PreparedStatement /-10221: Command info too long-10300: Invalid parameter index [<number>]-10301: Invalid host type (<name>) for parameter (<number>)-10304: Parameter/Column (<number>) not bound-10305: Parameter <number> contains null pointer-10306: Negative buffer length for parameter (<number>) used-10307: Invalid length or indicator value for parameter (<number-10308: Non-character and non-binary data for parameter (<number-10310: Invalid column index (<number>)-10312: Attempt to concatenate to a NULL or DEFAULT value for pa-10313: Requested parameter (<number>) was already processed-10314: Invalid parameter processing sequence, process non-LONG-10315: Invalid start position (<number>)-10316: DATA AT EXECUTE for parameter (<number>) not allowed (co-10317: LOB type for parameter (<number>) not allowed (conflicts-10318: Invalid LOB object-10319: Could not read/write LOB for parameter/column (<number>)-10320: LOB already closed for parameter/column (<number>)-10321: LOB invalidated by a previous error for parameter/column-10322: Could not insert LOB. Parameter/column (<number>) has a-10323: Non-character and non-binary data for parameter/column (-10324: Stream with id (<number>) not found-10325: Stream parameter (<number>) is not an input|output param-10326: No data found for stream (<number>)-10327: Invalid use of null pointer in stream parameter field of-10328: Mismatch of number of stream members for parameter (<num-10329: Invalid serial value requested, must be first or last va-10330: Multiple stream output sequence error-10331: Input stream callback buffer overflow for table id (<num-10332: No callback function supplied for stream parameter (<num-10400: Conversion looses significant digits for parameter/colum-10401: Conversion of parameter/column (<number>) would truncate-10404: Conversion not supported for parameter/column (<number>)-10405: Cannot convert UCS2 data to ASCII-10406: Invalid data length for UCS2 data for parameter/column (-10407: Corrupted UTF8 data for parameter/column (<number>)-10408: Character conversion failed-10410: Date/time format is not supported for parameter/column (-10411: Illegal DATE value for parameter/column (<number>)-10412: Illegal TIME value for parameter/column (<number>)-10413: Illegal TIMESTAMP value for parameter/column (<number>)-10414: Conversion from binary value to string is not supported-10500: Result set is closed-10501: Invalid position in result set: before first row-10502: Invalid position in result set: after last row-10503: The operation is not allowed for result set type FORWARD-10504: Invalid position (<row_number>) for row set-10505: Result set type is UPDATABLE but row set type is READ_ON-10506: Result set type is READ_ONLY but row set type is UPDATAB-10507: Internal error: No metadata available for row set operat-10508: Invalid encoding of column name for column (<number>) fo-10509: The statement was not executed with updatable cursor con-10601: SQL command is the empty string-10602: SQL command contains UNICODE character-10603: SQL command would generate a result set-10604: SQL command contains output parameters-10605: Illegal schema modification, parameters/columns have cha-10706: Statement too long-10709: Connection failed (<description>)-10715: Missing user name for connection | Missing password for-10757: XUSER error (<description>)-10802: Invalid numeric value for parameter/column (<number>)-10803: Allocation of shared memory failed (<description>)-10807: Connection down: [<description>]-10808: Feature <feature> not implemented yet in module: <module-10810: Session already in use-10811: Numeric overflow for parameter/column (<number>)-10821: Session not connected-10856: Invalid row array size 0-10857: Missing database name for connection-10861: Invalid use of null pointer for stream handle in paramet-10862: Stream parameter (<number>) error in read|write procedur-10899: Unknown error-10901: No space left in request packet-10902: Invalid request packet structure-10903: Internal Error: LONGDATA part expected-10904: Internal error: Expected result count-10905: Invalid reply packet structure-10906: Internal Error: Entry for valindex (<number>) not found-10907: Internal Error: Long descriptor has error flag set-11000 〜 -11099-11100 〜 -11199-11100: Unknown error-11101: Initialization failed [<description>].-11104: Session not connected.-11105: Cannot get column name for column <number>.-11106: No result set found.-11107: Statement not prepared.-11108: Invalid parameter index <number>.-11109: Column/Parameter <number> truncated.-11111: Parameter/Column (<number>) not bound.-11113: Number of parameters does not match number of result col-11115: Syntax error. Expected: <description>.-11116: Wrong parameter type. Expected: <description>.-22000 〜 -22999-22000: Null values not allowed on more than one long column-22005: Connection timeout occurred. Session reconnected-23000 〜 -23999-23050: Unknown error-23051: Could not load system tables for SQL Studio-23052: Could not save object data-23053: Cannot load proposal list-23054: Maximum numbers of windows reached-23055: Connection failed-23056: User is exclusive-23057: Reconnect failed-23058: No database connection-23059: You do not have the permission to modify this object-23060: You do not have the permission to delete this object-23061: Cannot analyze error-23062: Could not open connection-23063: Could not create Global Com Object-23064: Import failed-23070: Cannot open object created by newer SQL Studio Version-23071: Convert object created by older SQL Studio Version-23072: Representation of null value too long-23100: OLE Error! Please restart SQL Studio-23101: Data in clipboard truncated-23102: Failed to create DBC Pool-23103: Failed to create DBC Handle-23104: Could not load table definition-23200: No data sources-23201: No ODBC driver-23202: Could not load object description-23203: Cannot show tables of users, wrong database version!-24000 〜 -24999-24905: ERR_NOEBIDLIST: no information on external backup IDs av-24906: ERR_EBFDIRTY: invalid format of external backup history-24907: ERR_DBAWRONG - wrong SYSDBA-24909: ERR_DBAUNKNOWN - SYSDBA unknown-24910: ERR_PARAMVER - wrong version of param help file (cserv.p-24911: ERR_INVDBNAME - database name <database_name> is reserve-24912: ERR_WRONGINST - DBM server instroot is <inst_path>-24913: ERR_SERVICEDB - can not register service kernel for <ins-24914: ERR_KEYEXISTS - installation key <key> exists-24915: ERR_NOADDD - configuration update not allowed (param fil-24916: ERR_MAXVOLCNT - max volume count exceeded-24917: ERR_MAXDATA - max data size exceeded-24918: ERR_MISSMIRR - missing data for mirror volume-24919: ERR_CLEANUP: cannot free all operational resources after-24920: ERR_BACKUPOP: backup operation was unsuccessful-24921: ERR_POSTOP: error while finishing backup operation-24922: ERR_OPCHK: cannot check state of backup operation-24923: ERR_TOOLREQ: error while starting external backup tool-24924: ERR_DBREQ: cannot start database kernel request-24925: ERR_PREPARE: preparation of backup operation failed-24926: ERR_MEDIUMCHK: medium cannot be used with this external-24927: ERR_TOOLCHK: external backup tool not found-24928: ERR_NOREPLY - no reply available-24929: ERR_USRFRM - invalid user record format-24930: ERR_XPVALUESET - parameter value not in value set-24931: ERR_XPMIN - parameter value smaller than minimum allowed-24932: ERR_XPMIN - parameter value smaller than minimum allowed-24933: ERR_NOSERVICESESSION - no service kernel available-24934: ERR_VERSION - incompatible versions (param and kernel)-24935: ERR_NOUSERS - no users found-24936: ERR_DBNORUN - database is not running-24937: ERR_MISSRIGHT - no server rights for this command-24938: ERR_NOENTRY - no entry found-24939: ERR_LASTREG - cannot delete last registration of instanc-24940: ERR_NEEDSYSLOGON - system logon required-24941: ERR_NEEDLOGON - DBM server logon required-24942: ERR_USRDELSDBA - cannot delete sysdba-24943: ERR_USRDELDBM - cannot delete DBM operator-24944: ERR_USRDELSELF - cannot delete current user-24945: ERR_TOFEWPARAM - to few parameters-24946: ERR_TOMANYPARAM - to many parameters-24947: ERR_DBNAME - do not use dbname-24948: ERR_NODBNAME - database name required-24949: ERR_USREXISTS - user entry already exists-24950: ERR_USRFAIL - user authorization failed-24951: ERR_USRREAD - could not read user data-24952: ERR_USRSAVE - could not save user data-24953: ERR_DBEXIST - database instance already exists-24954: ERR_BANOAUTOMED - no autolog medium found in media list-24955: ERR_BANOSAVETYPE - backup type not defined-24956: ERR_BASAVETYPECON - backup type conflicts with medium de-24957: ERR_NOUSER - required user not set-24958: ERR_BAOVERWRITE - file already exists, cannot overwrite-24959: ERR_XPOVERFLOW - value out of margin-24960: ERR_DBRUN - database is running-24961: ERR_STATE - cannot determine current db state-24962: ERR_VOLTYPE - wrong volume type-24963: ERR_VOLCHECK - error while checking volume-24964: ERR_EXECUTE - error in program execution-24965: ERR_SYSLOGON - logon to system failed-24966: ERR_LOGON - logon to DBM server failed-24967: ERR_SYSTEM - system call error-24968: ERR_XPREADONLY - parameter is read only-24969: ERR_XPDIRTY - param file is dirty-24970: ERR_XPNOMODIFY - parameter must not be modified-24971: ERR_XPNOCHECK - no running parameter check-24972: ERR_XPINVCONF - invalid value-24973: ERR_XPCHECK - param check failure/request-24974: ERR_XPSESSION - param session active-24975: ERR_NOXPSESSION - param session inactive-24976: ERR_PARAMEXIST - param file of database already exists-24977: ERR_COMMAND - unknown command <command>-24978: ERR_XPSYNTAX - xparam syntax error-24979: ERR_XPNOTFOUND - parameter not found-24980: ERR_NOHELP - xparam help file not found-24981: ERR_HIENTRYNOTFOUND - backup history entry not found-24982: ERR_NOHISTORY - backup history file not found-24983: ERR_BANOVALIDTYPE - invalid backup type-24984: ERR_MENOVALID - invalid medium definition-24985: ERR_MENOTFOUND - medium not found-24986: ERR_NOMEDIA - media file not found-24987: ERR_TOSMALL - packet size too small for answer-24988: ERR_SQL - sql error-24989: ERR_NOHISTORYSESSION - no backup history session availab-24990: ERR_NOBACKUPSESSION - no backup session available-24993: ERR_RTEEXT - runtime environment error-24994: ERR_RTE - runtime environment error-24995: ERR_MEM - memory allocation error-24996: ERR_PARAM - wrong parameters-24997: ERR_FILE - file handling error-24998: ERR_NOTIMPL - sorry, command not yet implemented-24999: ERR - common error-25000 〜 -25999-25002: No database connection possible - missing database name;-25003: Getting hostname of database host failed: <error_code> =-25004: A connection to the database could not be established: <-25005: User (<user_name>) logon to database failed: <error_text-25006: Connect with userkey '<user_key>' failed: <error_text>-25007: No connection to server db '<database_name>' established-25008: Logon failure; previous user's (<user_name>) connection-25009: Failure in db communication (<type>): <return_code> = <e-25010: <SQL_error_text>-25011: Error executing internal SQL statement '<statement>' : '-25012: No user connection to server db established-25018: Error changing log file owner to current user '<user_nam-25019: Error opening server log file '<log_file_name>' (<error_-25020: No more memory available-25021: Error switching connected user to <user_name> : <error_t-25022: Received cancel request; stopping execution-25024: Error switching current schema to <schema_name> ; <error-25109: Command not implemented-25201: Column '<column_name>' - INTEGER field: 1, 2 or 4 bytes-25202: Column '<column_name>' - REAL field: 4 or 8 bytes long (-25203: Column '<column_name>' - DECIMAL field: 20 bytes maximum-25204: Column '<column_name>' - ZONED field: 20 bytes maximum (-25205: Declare USAGE between 50% and 100%-25206: USAGE value of '0 rows' not allowed-25207: USAGE value of row(s) too high; maximum number of record-25208: Invalid position specification (negative values not allo-25209: Invalid FRACTION specification (neg. vals not allowed)-25210: Invalid SCALE spec. Scale range: -127 <= SCALE <= 127-25211: Invalid ROUND specification (0 <= ROUND_value <= 18)-25212: Invalid TRUNC specification (0 <= TRUNC_value <= 18)-25213: Invalid file format specification: given formats rule ea-25214: The specification of a separator/delimiter is not allowe-25216: File option FWV required-25217: End position for column <column_name> lower than start p-25218: No column specified but file format is FWV-25219: Columns have to be specified in left-to-right order (pos-25220: Wrong separator/delimiter specification-25221: Wrong decimal specification-25222: Wrong Boolean specification-25223: Wrong null specification-25225: Wrong number specification-25226: A maximum of 1024 columns can be specified for one table-25227: Specification of conditions exceeds allowed count of con-25228: Incorrect date-time format, all patterns accepted in the-25229: Incorrect comparison operator in condition-25230: Cannot execute command DATAEXTRACT FOR <load_type>; spec-25231: ROUND or TRUNC specification not allowed for this column-25232: Wrong keyword-25233: Some column descriptions with end position but file form-25234: Some column descriptions without end position but file f-25235: Some positions specified more than once-25236: Some positions overlap-25237: Cannot execute DATAUPDATE command; specify set columns-25238: Cannot execute DATAUPDATE command; specify access column-25239: Specified value '<value>' is not a valid integer-25240: Incomplete logon parameters; password missing-25242: Database identifier too long-25243: Error parsing <time> mask: <error_text>-25244: Loader CONSTRAINT violation: <error_text>-25245: Error: specify CATALOG, DATA, and PACKAGE stream-25247: Error: specify CATALOG or DATA stream-25249: Invalid Isolation Level specification: possible values a-25250: Error building URI for encrypted connection: <error_text-25251: Code page to set (<code_page_name>) not found in system-25281: Syntax error at position <position> (<error_text>). Chec-25301: Invalid input for date or time column: <input_value>-25302: This value is not a valid number: '<input_value>'-25303: Input value does not match key order or range specificat-25304: Columns for key (KEY) or search condition missing-25305: Data for key columns exceeds allowed key length-25306: The value is not a valid HEX constant: <input_value>-25308: CONSTRAINT condition violated-25309: Invalid input for BOOLEAN column: <input_value>-25310: Column '<column_name>' must not contain NULL values-25311: No Data for NOT NULL - column without default (<column_n-25313: Overflow occurred, execution aborted-25314: Fractional part too small for column '<column_name>', mi-25315: Column data type of column '<column_name>' and external-25316: Table contains at least one column defined as LONG; IMPO-25317: Constant must be compatible with column type and length-25318: Syskey violation (the computed value exceeds the highest-25319: Missing data for specified column '<column_name>'-25320: The LONG value could not be loaded into column-25321: This condition value is not a valid number: '<value>'-25322: This condition value was truncated and cannot be used: '-25323: Data type of null value representation for column '<colu-25324: Errors checking length of column specifications. See Loa-25325: Errors checking compatibility of external and db data ty-25326: The exported number (column '<column_name>') was truncat-25327: Error(s) exporting record <record_no>; start position of-25328: Some error(s) while extracting data. See Loader server l-25329: The given data file '<file_name>' was not generated usin-25330: The page sizes of the source system and the target syste-25331: This is a restricted statement, user must be SYSDBA-25332: Error getting schema definition of table <table_name> (<-25333: Error getting index definitions for table <table_name> (-25334: File counter for data file exceeded maximum value of 999-25335: Error restoring single table using data file with multip-25336: Error restoring multiple tables using data file with sin-25337: Error restoring table <table_name>; no table data found-25338: Error during restart IMPORT; restart entry <position> no-25339: Error during restart IMPORT; file <file_name> could not-25340: UCS2 conversion error; character string contains invalid-25341: Error generating 'create table/index statements': <error-25342: Error restoring table <table_name>; table exists but sou-25343: Column name(s) or number(s) do not match column names/nu-25344: Incorrect field length for column '<column_name>', minim-25345: Definition of source and target table <table_name> do no-25346: Communication packet size too small to run IMPORT for PA-25347: Encoding type of source and target database do not match-25348: Different byte swap of source and target computer. The L-25349: Error exporting <type> data of table <table_name>. See L-25350: Conversion from UNICODE data to ASCII data is not suppor-25351: No long file info given for LONG column '<column_name>'-25352: Errors analyzing long file information. See loader serve-25353: Specified maximum number of LONG data files for column '-25354: LONGFILE specification missing or incorrect-25355: Error processing LONG value (column '<column_name>'): <e-25356: Error processing LONG value(s): <error_text>-25364: Name of table to import <table_name> and the table curre-25365: Data file corrupted: trailer not found-25366: Data file corrupted: header not found-25371: Error converting data from <source_encoding> to <target_-25390: Error generating CREATE TABLE/INDEX statements. Table na-25391: SQL statement is too long-25392: [SAP AG][SQLOD32 DLL][MaxDB] <error_text>-25393: Error during check if table <table_name> exists <error_t-25394: Catalog of table <table_name> changed while processing <-25401: Error reading system table SYSLOADER.CODEPAGE-25402: Error creating/granting system table SYSLOADER.CODEPAGE-25403: Error opening/reading code page file <code_page>. Can't-25404: Invalid HEX constant <hex_value> found in code page file-25405: Invalid ASCII values read or values not sorted in ascend-25451: Integrity violation (SQL_Error)-25498: Errors processing data for table <table_name>; No data i-25499: Errors processing data for table <table_name>. Data not-25500: Errors processing command exceed maximum number of error-25501: Error opening file <file_name> : <error_text>-25502: Error closing file <file_name> : <error_text>-25503: Error reading file <file_name> : <error_text>-25504: Error writing file <file_name> : <error_text>-25505: Error erasing file <file_name> : <error_text>-25507: Error truncating file <file_name> : <error_text>-25508: File <file_name> is not encoded as <encoding>-25551: Error importing statistics: <error_text>-25552: Error exporting statistics: <error_text>-25601: Error restoring table <table_name>. Table does not exist-25602: Error restoring table <table_name>. Table is not empty.-25603: Error processing IMPORT in PAGE Format. Loader versions-25801: Internal error [<file_name>,<line_no>,<error_code>]. Con-27000 〜 -28999-27000: Unknown error-27003: Numeric input parameter overflow-27006: Incompatible data types-27009: Command too long-27014: Connect not ok-27015: Connection down-27016: DB shut down-27017: Too many volumes-27018: Connection error-27019: Conversion UNICODE to ASCII not possible-28001: Access via NIL OID-28002: Invalid OID-28003: Unknown GUID-28005: Duplicate object-28006: Object not locked-28007: OID not compatible with given class-28501: Error reading OMS input stream-28502: Error writing OMS output stream-28503: Crash in DB Procedure-28505: No Component Object found-28508: Unsupported parameter type-28514: Unknown OMS Version-28515: OMS Version already open-28516: Commit or Rollback required-28517: Already in Critical Section-28518: Not in Critical Section-28521: Already in version-28522: Missing before image-28523: Unknown schema-28524: Duplicate schema-28525: Procedure Address not found-28527: Directory not found-28529: Too small name buffer-28530: omsTerminate called-28531: OMS read only-28532: Version bound by transaction-28533: Integer out of packed range-28534: Package must be recreated-28600: Invalid request code in packet-28601: Object data packet for read missing-28602: Packet size does not match object size-28603: Requested packet size to transfer an object is too big-28604: Trying to queue too many data packets when sending objec-28605: Invalid operation in UDE Server-Kernel communication-28606: Communication error-28607: Missing object data packet-28608: Invalid reply for stored procedure-28609: Stored procedure not found-28801: Wrong class id-28802: Wrong object version-28803: Wrong object version-28804: Too old OID-28806: Nil page pointer-28808: Hash not found-28810: Duplicate hash key-28813: Unknown consistent version-28814: Object not found-28815: Object history not found-28817: Wrong object length-28818: Wrong object position-28819: Object has been updated by other transactions-28823: Page already in use-28826: Pagecounter inconsistent-28828: Inconsistent information concerning “is container dropp-28902: Too many nested try/catch statements-28903: DBFunction$1 must return a value-28822 〜 -28999: Internal Error0 〜 19990: Success100: Row not found200: Duplicate key250: Duplicate secondary key300: Integrity violation320: View violation350: Referential integrity violated360: Foreign key integrity violated400: Lock collision500: Lock request timeout600: Work rolled back650: Work rolled back700: Session inactivity timeout (work rolled back)710: Session terminated by shutdown (work rolled back)750: Too many SQL statements (work rolled back)1403: Row not found25000 〜 2599925599: Value for usage <number> rows too high to fit into one da25600: CONFIGURATION stream is not supported for this Loader com25601: Output of NULL values for column <column_name> will be tr25602: Possible overflow of integer values for column '<column_n25603: Output of literal '<literal>' will be truncated25604: Surplus long file info (column name/id '<column_name>') i25605: No header in binary data file and no record length in com25606: Different byte swap of source and target machine; long va25607: Value for usage <value>% too less to fit one row into one25608: Restart file <file_name> not found; starting import from25913: Table <schema_name>. <table_name> not imported25921: Range of SEQUENCE is exhausted25940: Error at record <record_count> in input file for table <t25965: No data to import in datastream <file_name>; either the s25966: Error at record <record_count> in input file <file_name>25967: Error at position <file_position> in input file <file_nam25968: Number of NULL values inserted: <null_count> (NULL represMaxDB セキュリティガイドはじめに基本情報テクニカルシステムランドスケープユーザ管理および認証標準ユーザのパスワード変更ログオン試行に失敗した場合のログファイルのチェック権限ユーザの明確な権限の定義ネットワークおよび通信のセキュリティ通信チャネルの保護ファイアウォール内部での MaxDB X Server の使用ファイアウォール内部での Web ツールの使用データ記憶域のセキュリティDB リソースへのアクセス制限 (DB Ver. 7.4.03 以前の UNIX/Linux)データベースリソースへのアクセス制限 (Microsoft Windows)SAP 標準オペレーティングシステムユーザのパスワード変更セキュリティに影響を及ぼす不要な機能ローカル通信での MaxDB X Server のスイッチオフNI でのサポートのない MaxDB X Server の起動 (Unix/Linux)デモデータの削除他のセキュリティ関連情報SQL 文のユーザ入力のチェックトレースおよびログファイルログファイルへのアクセス制限添付文書