GrundwissenKonzepte des DatenbanksystemsInformationen zur SoftwareSAP DB und MaxDBDokumentationDemo-DatenbankObjekte im Schema HOTELDownloadVersionsnotierungUnterstützte Betriebssysteme und ArchitekturenOpen-Source-Entwicklung der DatenbanksoftwareSupportProblemmeldungen mit Web PTS verfolgenDas Datenbanksystem im ÜberblickSQLTransaktionenProtokollierung von Datenänderungen (Logging)History-VerwaltungBeispiel: RestartBeispiel: Konsistente SichtSperren für DatenbankobjekteLesesperreSchreibsperreOptimistische SperrePhänomeneParallelität von SperrenIsolation-LevelDatenspeicherungArbeitsspeicherbereicheVolumes (permanenter Speicher)SavepointLogische ZugriffsstrukturenB*-Bäume für Tabellen mit LONG-SpaltenB*-Bäume für Tabellen mit IndizesBelegungsausgleichBeispiel: SELECT-AnweisungBeispiel: INSERT-AnweisungBeispiel: DELETE-AnweisungBeispiel: UPDATE-AnweisungConverterDatenbankwerkzeugeSchnittstellenTechnische SystemlandschaftNetzwerkkommunikationArchitektur der DatenbankwerkzeugeArchitektur der SchnittstellenDatenverschlüsselungBeispiel: Systemlandschaft mit MaxDB-DatenbankinstanzBeispiel: SAP-Systemlandschaft mit zwei MaxDB-DatenbankinstanzenProzessstrukturÜbersicht der ProzesseÜbersicht der DiensteÜbersicht der TasksÜbersicht der Task-ZuständeTask-WechselLoad-BalancingÜbersicht der Spezial-ThreadsAnlegen und Konfigurieren einer DatenbankinstanzDatenbankinstanz planenTechnische RestriktionenVorlagen für DatenbankinstanzenKonventionen für DatenbanknamenDatenbankparameterAllgemeine DatenbankparameterSpezielle DatenbankparameterSupport-DatenbankparameterliveCache-DatenbankparameterEigenschaften von DatenbankparameternAutomatischer StartBeispiel: Startskript für eine Datenbankinstanz (Linux)Log-EinstellungenKonfigurationsdateienDatenbankdesignTipps zum Datenbank-DesignVerwaltungRegelmäßige VerwaltungsaufgabenVerwaltungsaufgaben automatisierenÜbersicht der Datenbank-Event-KategorienBenutzer, Authentifizierung und BerechtigungenDatenbanksystemadministrator (SYSDBA-Benutzer)Database Manager-Benutzer (DBM-Benutzer)DatenbankbenutzerServerberechtigungen für den DBM-ServerKonventionen für Benutzernamen und KennwörterAuthentifizierungSpezielle Betriebssystembenutzer und -gruppen (UNIX/Linux)<sdb_user> (spezieller Betriebssystembenutzer)<sdba_group> (spezielle Betriebssystemgruppe)Supportgruppe (spezielle Betriebssystemgruppe)Sichern und WiederherstellenSicherungsvorlagen und DatenträgerHinweise zu den verschiedenen Typen von DatenträgernDaten sichernLog-Einträge sichernSicherungsdateien archivierenDatenbankinstanz wiederherstellenBeispiel: Sichern und WiederherstellenSichern/Wiederherstellen mit entfernten RechnernSicherungswerkzeuge anderer Anbieter verwendenDatenbereich einfrieren (Snapshot)Exportieren und ImportierenReplikation und High-AvailabilityDatenbankkopieKompatible Prozessorarchitekturen für DatenbankkopienSchattendatenbankEinrichten einer SchatteninstanzAktualisieren der SchatteninstanzInbetriebnahme der Schatteninstanz als aktive InstanzHot-StandbySystemanforderungen für ein Hot-Standby-SystemArchitektur eines Hot-Standby-SystemsSynchronisation von Master- und Standby-InstanzenVerhalten des Hot-Standby-Systems im FehlerfallSynchronisationÜberwachungPerformancePerformance-Engpässe analysierenAutomatisches Umformen von SQL-AnweisungenSQL-OptimiererArbeitsweise des SQL-OptimierersSuchbedingungenGleichheitsbedingungBereichsbedingungIN-BedingungLIKE-BedingungEinschränkungen für UPDATE-AnweisungenKostenermittlungStatistiken des SQL-OptimierersSuchstrategienSequentielle SucheSuchbedingungen für SchlüsselspaltenSuchbedingungen für indizierte SpaltenMit OR verknüpfte SuchbedingungenVerlagerung der Suche auf den FETCH-ZeitpunktJoinsDatenbankparameter JOIN_SEARCH_LEVELListe aller SuchstrategienCATALOG 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 SCANProblemanalyseEXPLAIN-AnweisungEXPLAIN-Anweisung für JoinsEXPLAIN-Anweisung für komplizierte SELECT-AnweisungenEXPLAIN-Anweisung für SELECT-Anweisungen mit UnterabfragenSpalte STRATEGYFehlersucheTypische FehlersituationenProtokolldateienTracesDatenbankstrukturen prüfenFehler in der Datenstruktur behebenBeispiel: Fehler in der DatenstrukturEntwicklung von DatenbankanwendungenGlossarAVerwaltungAfter-ImageAnwendungsdatenArchitekturASCIIAuthentifizierungBerechtigungAUTOCOMMIT-ModusAutomatische Log-SicherungAutomatischer StartAutomatisierungBB*-BaumBackint for MaxDBSichernSicherungsdateiSicherungshistorieSicherungskennungSicherungsmediumSicherungsvorlageSicherungswerkzeugSicherungsartBefore-ImageBLOBCCacheCatalog-CacheCheckpointCLOBCodeattributSpalteKommandomodusKommandomonitorCOMMITKommunikationsserverVollständige DatensicherungKomponentengruppeKonfigurationKonfigurationsverzeichnisKonfigurationsdateiKonsistente SichtConstraintKontrollstrukturConverterKostenKritischer AbschnittCursorDDatenzugriffDatenbereichDatensicherungData-CacheDatenträgerDatenintegritätDatensatzDatentypData-VolumeData-WriterDatenbankDatenbankadministrator (DBA-Benutzer)Database AnalyzerDatenbankanwendungDatenbankkatalogDatenbankverbindungDatenbankkopieDatenbankdesignDatenbankdateiDatenbankfunktionDatenbank-IDDatenbankinstanzDatabase ManagerDatabase Manager-Benutzer (DBM-Benutzer)DatenbanknameDatenbankobjektDatenbankparameterDatenbankprozedurDatenbanksitzungDatenbankstrukturDatenbanksystemDatenbanksystemadministrator (SYSDBA-Benutzer)DatenbankwerkzeugDatenbank-TraceDatenbankbenutzerDBADBA-EinplanungskalenderDBADMINDBM-KommandoDBM-BenutzerDBM-BenutzereigenschaftenDBM-OptionDBM-ServerDBMCLIDBMGUIDDL-AnweisungVorschlagsparameterdateiDemo-DatenbankEntwicklungVerzeichnisstrukturDokumentationVariablen in der DokumentationWertebereichDownloadEVerschlüsselungUmgebungsvariableFehlermeldungEventEvent-DispatcherBeispielSchreibsperreAusführungsplanEXPLAIN-AnweisungExportierenExternes SicherungswerkzeugFFBM (Free Block Management)DateiklasseDateiverzeichnisDatei-IDFremdschlüsselGGarbage-CollectorHHigh-AvailabilityHistory-DateiTrefferquoteHomogene SystemkopieHot-StandbyII/O-Buffer-CacheImportierenInkrementelle DatensicherungIndexIndizierte SpalteInitialisierenInstallationInstallation ManagerInstallationsprofilInteraktive Log-SicherungSchnittstelleDatenbankinterne DateiInvertierungslisteInvertierte SpalteIsolation-LevelJJavaJDBCJoinKKernKernprotokollKernvarianteSchlüsselwortKNLDIAGLSprachunterstützung (Mapchar-Sets)BlattseiteliveCache (SAP liveCache-Technologie)Load-BalancingLoaderLoader-ServerLadenLOBSperreSperrlisteLog-BereichLog-SicherungLog-EintragProtokolldateiLog-ModusLog-SeiteLog-WarteschlangeLog-LeserLog-SegmentLog-EinstellungLog-VolumeLog-WriterLoggingLONG-WertMMailing-ListeMapchar-SetMaster-InstanzMaxDBMergeMessage-ServerMigrationÜberwachungMulti-Prozessor-KonfigurationNNamenskonventionenNetzwerkOODBCOLTP (MaxDB)OMSOMS-HeapOMS-VersionOpen-Source-EntwicklungBetriebssystembenutzerBetriebsmodusBetriebszustandOptimistische SperreOptimiererÜberschreibmodus für den Log-BereichEigentümerPSeiteSeitenkettePagerParallele SicherungParameterParameterdateiParameter in SQL-AnweisungenPerformancePerlPHPPortPrecompilerPrädikatPrepared StatementPrimärschlüsselPrivilegProzessProgrammierschnittstellePTS (Problem Tracking System)PythonQQuery ToolRRaw-DeviceReader-Writer-LockRedo-ListeRedo-Log-EintragRedo-Log-DateiRedo-Log-VerwaltungRedo-Log-ManagerRedo-TaskRegionReorganisationReplikationReplikationstabelleReplikationseinheitReserviertes WortRESOURCE-BenutzerRessourcenmonitorRestartRestart-InformationWiederherstellenRestriktionRolleROLL FORWARDROLLBACKZeileArbeitsverzeichnisSSAP DBSavepointSchedulerSchemaSkriptmodussdbsdbaSuchstrategieSekundärschlüsselSelektivitätSeparatorSequenzSequence-CacheServerberechtigungServer-TaskDienstService-DatenbankinstanzService-SitzungSitzungsmodusLesesperreShared-MemoryShared-SQLSnapshotSoftwarekomponenteSpezial-ThreadSQLSQL-ModusSQL-OptimiererSQL-SitzungSQL-AnweisungSQL StudioSQL-TutorialSQLCLISQLDBCSSL/TLSSTANDARD-BenutzerSchattendatenbankStandby-InstanzStartenStatistikenStored ProcedureStrategieSubtransaktionSupportSynchronisationSynchronization ManagerSynchronisationsbenutzerSynonymSyntaxnotationSYSDBA-BenutzerSystemausfallSystemkopieSystemvoraussetzungenSystemtabelleSystem-TriggerTTabelleTabellen-IDTabellennameTaskTask-ZustandVorlage für eine DatenbankinstanzThreadTimeoutTimer-TaskWerkzeugTraceTrace-Writer-TaskTransaktionTransaktionsdateiTransaktionslisteTriggerFehlersucheTutorialUUndo-Log-EintragUndo-Log-DateiUnicodeEntladenUpdateUpgradeBenutzerBenutzergruppeUser-Kernel-ThreadBenutzerschlüsselUser-TaskBenutzerdefinierte FunktionUtility-TaskVVariableVersionViewView-TabelleVirtueller RechnerVMAKEVolumevservervtraceWWeb DBMWeb ServerWeb Server ManagerWeb SQLWeb ToolWebDAVArbeitsspeicherXX-ServerXCONS (Datenbankkonsole)XUSERYZ
Deutsche Sortierung - GlossarSQL-ReferenzhandbuchDatendefinitionDatenintegrität absichernCREATE TABLE-Anweisung (create_table_statement)Spaltendefinition (column_definition)Datentyp (data_type)CHAR[ACTER]VARCHARLONG [VARCHAR]CodeattributBOOLEANFIXEDFLOATINT[EGER]SMALLINTDATE (Datumswert)TIME (Zeitwert)TIMESTAMP (Zeitstempelwert)NULL-WertSpezial-NULL-WertZahlZeichenketteSpaltenattribute (column_attributes)Platzbedarf eines Spaltenwertes in Abhängigkeit vom DatentypCONSTRAINT-Definition (constraint_definition)Referentielle CONSTRAINT-Definition (referential_constraint_defiSchlüsseldefinition (key_definition)UNIQUE-Definition (unique_definition)DROP TABLE-Anweisung (drop_table_statement)ALTER TABLE-Anweisung (alter_table_statement)ADD-Definition (add_definition)ALTER-Definition (alter_definition)COLUMN-Change-Definition (column_change_definition)DROP-Definition (drop_definition)MODIFY-Definition (modify_definition)RENAME TABLE-Anweisung (rename_table_statement)RENAME COLUMN-Anweisung (rename_column_statement)EXISTS TABLE-Anweisung (exists_table_statement)CREATE SCHEMA-Anweisung (create_schema_statement)RENAME SCHEMA-Anweisung (rename_schema_statement)DROP SCHEMA-Anweisung (drop_schema_statement)CREATE DOMAIN-Anweisung (create_domain_statement)DROP DOMAIN-Anweisung (drop_domain_statement)CREATE SEQUENCE-Anweisung (create_sequence_statement)DROP SEQUENCE-Anweisung (drop_sequence_statement)CREATE SYNONYM-Anweisung (create_synonym_statement)DROP SYNONYM-Anweisung (drop_synonym_statement)RENAME SYNONYM-Anweisung (rename_synonym_statement)CREATE VIEW-Anweisung (create_view_statement)INSERT-/UPDATE-/DELETE-Privileg für Eigentümer der View-TabelleÄnderbare Join-View-TabelleDROP VIEW-Anweisung (drop_view_statement)RENAME VIEW-Anweisung (rename_view_statement)CREATE INDEX-Anweisung (create_index_statement)DROP INDEX-Anweisung (drop_index_statement)ALTER INDEX-Anweisung (alter_index_statement)RENAME INDEX-Anweisung (rename_index_statement)CREATE DBPROC[EDURE]-Anweisung (create_dbproc_statement)Routine (routine)Allgemeine CASE-Anweisung (searched_case_statement)Einfache CASE-Anweisung (simple_case_statement)DROP DBPROC[EDURE]-Anweisung (drop_dbproc_statement)CREATE SYSTEM TRIGGER-Anweisung (create_system_trigger_statementDROP SYSTEM TRIGGER-Anweisung (drop_system_trigger_statement)CREATE FUNCTION-Anweisung (create_function_statement)DROP FUNCTION-Anweisung (drop_function_statement)CREATE TRIGGER-Anweisung (create_trigger_statement)DROP TRIGGER-Anweisung (drop_trigger_statement)COMMENT ON-Anweisung (comment_on_statement)AutorisierungCREATE USER-Anweisung (create_user_statement)CREATE USERGROUP-Anweisung (create_usergroup_statement)DROP USER-Anweisung (drop_user_statement)DROP USERGROUP-Anweisung (drop_usergroup_statement)ALTER USER-Anweisung (alter_user_statement)ALTER USERGROUP-Anweisung (alter_usergroup_statement)RENAME USER-Anweisung (rename_user_statement)RENAME USERGROUP-Anweisung (rename_usergroup_statement)GRANT USER-Anweisung (grant_user_statement)GRANT USERGROUP-Anweisung (grant_usergroup_statement)ALTER PASSWORD-Anweisung (alter_password_statement)CREATE ROLE-Anweisung (create_role_statement)DROP ROLE-Anweisung (drop_role_statement)GRANT-Anweisung (grant_statement)REVOKE-Anweisung (revoke_statement)DatenmanipulationINSERT-Anweisung (insert_statement)Datentyp der Zielspalte und Datentyp des einzufügenden WertesJoin-View-Tabelle, QUERY-Ausdruck, CONSTRAINT-Definition, TriggeUPDATE-Anweisung (update_statement)DELETE-Anweisung (delete_statement)NEXT STAMP-Anweisung (next_stamp_statement)CALL-Anweisung (call_statement)DatenanfrageQUERY-Anweisung (query_statement)DECLARE CURSOR-Anweisung (declare_cursor_statement)Rekursive DECLARE CURSOR-Anweisung (recursive_declare_cursor_staSELECT-Anweisung (select_statement)QUERY-Ausdruck (query_expression)Tabellenausdruck (table_expression)Subquery (subquery)ORDER-Klausel (order_clause)UPDATE-Klausel (update_clause)LOCK-Option (lock_option)FETCH-Anweisung (fetch_statement)CLOSE-Anweisung (close_statement)SINGLE SELECT-Anweisung (single_select_statement)EXPLAIN-Anweisung (explain_statement)TransaktionenCONNECT-Anweisung (connect_statement)SET-Anweisung (set_statement)COMMIT-Anweisung (commit_statement)ROLLBACK-Anweisung (rollback_statement)SUBTRANS-Anweisung (subtrans_statement)INNER TRANSACTION-Anweisung (inner_transaction_statement)SQL SAVEPOINT-Anweisungen (savepoint/rollback_to_/release_savepoLOCK-Anweisung (lock_statement)UNLOCK-Anweisung (unlock_statement)RELEASE-Anweisung (release_statement)StatistikenUPDATE STATISTICS-Anweisung (update_statistics_statement)MONITOR-Anweisung (monitor_statement)SQL-Anweisungen: ÜberblickKommentar (sql_comment)Häufig verwendete Syntaxelemente: ÜberblickCASCADE-Option (cascade_option)Zeichen (character)Spaltenspezifikation (column_spec)DEFAULT-Spezifikation (default_spec)DELETE-Regel (delete_rule)DISTINCT-Spezifikation (distinct_spec)DUPLICATES-Klausel (duplicates_clause)Ausdruck (expression)Spezifikation von Werten (extended_value_spec)Funktion (function_spec)Arithmetische Funktion (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)Konversionsfunktion (conversion_function)CHAR(a,t)CHR(a,n)HEX(a)HEXTORAW(a)NUM(a)Datums- und Zeitformat (datetimeformat)Datumsfunktion (date_function)ADDDATE/SUBDATE(t,a)DATEDIFF(t,s)DAYNAME/MONTHNAME(t)DAYOFWEEK/WEEKOFYEAR/DAYOFMONTH/DAYOFYEAR(t)MAKEDATE(a,b)Datenbankfunktionsaufruf (dbfunction_call)Extraktion (extraction_function)DATE(a)HOUR/MINUTE/SECOND(t)MICROSECOND(a)TIME(a)TIMESTAMP(a,b)YEAR/MONTH/DAY(t)Spezialfunktion (special_function)DECODE(x,y(i),...,z)GREATEST/LEAST(x,y,...)VALUE(x,y,...)Allgemeine CASE-Funktion (searched_case_function)Einfache CASE-Funktion (simple_case_function)Stringfunktion (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)Verkettung (concatenation)Zeitfunktion (time_function)ADDTIME/SUBTIME(t,a)MAKETIME(h,m,s)TIMEDIFF(t,s)Trigonometrische Funktion (trigonometric_function)Join-Tabelle (joined_table)Schlüsselspezifikation (key_spec)Literal (literal)Festkommazahl (fixed_point_literal)Gleitkommazahl (floating_point_literal)Ganze Zahl ohne Vorzeichen (unsigned_integer)Ganze Zahl (integer)Parameterspezifikation (parameter_spec)Prädikat (predicate)BETWEEN-Prädikat (between_predicate)Boolesches Prädikat (bool_predicate)Vergleichsprädikat (comparison_predicate)DEFAULT-Prädikat (default_predicate)EXISTS-Prädikat (exists_predicate)IN-Prädikat (in_predicate)JOIN-Prädikat (join_predicate)LIKE-Prädikat (like_predicate)NULL-Prädikat (null_predicate)Mengenvergleichsprädikat (quantified_predicate)ROWNO-Prädikat (rowno_predicate)SOUNDS-Prädikat (sounds_predicate)SAMPLE-Definition (sample_definition)Suchbedingung (search_condition)Selektierte Spalte (select_column)Set-Funktion (set_function_spec)Zeichensatz (token)Bezeichner (identifier)Schlüsselwort (key_word)Funktionen: ÜberblickNamen: ÜberblickAlias-Name (alias_name)Spaltenname (column_name)Constraint-Name (constraint_name)Name einer Datenbankfunktion (dbfunction_name)Name einer Datenbankprozedur (dbproc_name)Domänenname (domain_name)Indexname (index_name)Indikatorname (indicator_name)Mapchar-Set-Name (mapchar_set_name)Kennwort (password)Parametername (parameter_name)Referenzname (reference_name)Name eines Referentiellen Constraints (referential_constraint_naErgebnistabellenname (result_table_name)Rollenname (role_name)Schemaname (schema_name)Sequenzname (sequence_name)Synonymname (synonym_name)Tabellenname (table_name)Triggername (trigger_name)Benutzergruppenname (usergroup_name)Benutzername (user_name)Privilegien: ÜberblickPrivilegienspezifikation (priv_spec)Privilegienspezifikation für ein Schema (schema_priv_spec)Syntaxverzeichnisadd_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_statementSyntaxnotationSyntaxänderungenSystemtabellenAllgemeine HinweiseDatenbankbegriffeSystemtabellen auswerten (Beispiele)ACTIVECONFIGURATIONCACHESTATISTICSCOLUMNSCONSTRAINTSDATASTATISTICSDATAVOLUMESDBPROCEDURESDBPROCPARAMSDOMAINCONSTRAINTSDOMAINSFOREIGNKEYCOLUMNSFOREIGNKEYSFUNCTIONSINDEXCOLUMNSINDEXESINSTANCELOCKSLOGQUEUESTATISTICSLOGSTATISTICSMAPCHARSETSROLEPRIVILEGESROLESSEQUENCESSESSION_ROLESSESSIONSSYNONYMSTABLEPRIVILEGESTABLESTRIGGERSUSERSVERSIONVIEWCOLUMNSVIEWDEFSVIEWSDefinitionen der SystemtabellenACTIVECONFIGURATIONBACKUPTHREADSCACHESTATISTICSCATALOGCACHESTATISTICSCLASSCONTAINER_CHAINSCLASSCONTAINER_KEYSCLASSCONTAINER_ROOTSCLASSCONTAINERSCODEPAGECOLUMNSCOMMANDCACHESTATISTICSCOMMANDCACHESTATISTICSRESETCOMMANDSTATISTICSCOMMANDSTATISTICSRESETCONNECTEDUSERSCONNECTPARAMETERSCONSISTENTVIEWSCONSTRAINTCOLUMNSCONSTRAINTSDATACACHEDATASTATISTICSDATASTATISTICSRESETDATAVOLUMESDBPARAMETERSDBPROCEDURESDBPROCPARAMSDOMAINCONSTRAINTSDOMAINSFILEDIRECTORIESFILESFOREIGNKEYCOLUMNSFOREIGNKEYSFUNCTIONSGARBAGECOLLECTOR_STATISTICSHISTORYINFOHOTSTANDBYCOMPONENTHOTSTANDBYGROUPINDEXCOLUMNSINDEXESINDEXSIZEINDEXSTATISTICSINDEXSTORAGEDETAILSINSTANCEIOBUFFERCACHESIOTHREADSTATISTICSIOTHREADSTATISTICSRESETLOCKLISTSTATISTICSLOCKSLOCK_WAITSLOGINFORMATIONLOGQUEUESTATISTICSLOGQUEUESTATISTICSRESETLOGSTATISTICSLOGSTATISTICSRESETLOGVOLUMESMACHINECONFIGURATIONMACHINEUTILIZATIONMAPCHARSETSMEMORYALLOCATORSTATISTICSMONITORMONITOR_CACHESMONITOR_LOADMONITOR_LOCKMONITOR_LOGMONITOR_LONGMONITOR_OMSMONITOR_PAGESMONITOR_REWRITEMONITOR_ROWMONITOR_TRANSOBJECTLOCKSOMS_HEAP_STATISTICSOMS_LOCKOBJ_INFOOMSLOCKSOMS_VERSIONSOPTIMIZERINFORMATIONOPTIMIZERSTATISTICSPACKAGESPOSTUPGRADECHECKLISTREADERWRITERLOCKINFORMATIONREADERWRITERLOCKSTATISTICSREADERWRITERLOCKSTATISTICSRESETREADERWRITERLOCKWAITINGTASKSREGIONINFORMATIONREGIONSTATISTICSREGIONSTATISTICSRESETRESTARTINFORMATIONROLEPRIVILEGESROLESSCHEMAPRIVILEGESSCHEMASSCHEMASIZESEQUENCEPRIVILEGESSEQUENCESSERVERDBSTATISTICSSERVERTASKSSESSION_ROLESSESSIONSSNAPSHOTSSPINLOCKPOOLSTATISTICSSPINLOCKPOOLSTATISTICSRESETSPINLOCKSTATISTICSSPINLOCKSTATISTICSRESETSYNONYMSSYSTEMTRIGGERSSYSUPDATECOUNTERWANTEDSYSUPDSTATWANTEDSYSUPGRADEHISTORYTABLEPRIVILEGESTABLESTABLESIZETABLESTATISTICSTABLESTORAGEDETAILSTASKGROUPSTATISTICSTASKGROUPSTATISTICSRESETTASKLOADBALANCINGINFORMATIONTASKLOADBALANCINGTASKGROUPSTATESTASKLOADBALANCINGTASKMOVESTRANSACTIONHISTORYTRANSACTIONSTRANSACTIONSTRANSFORMATIONMODELTRANSFORMATIONMONITORTRANSFORMATIONPACKAGESTRANSFORMATIONRESOURCESTRANSFORMATIONSTATISTICSTRANSFORMATIONSTEPSTRIGGERSUNLOADEDSTATEMENTSUSERSUSERSTATISTICSVERSIONVERSIONSVIEWCOLUMNSVIEWDEFSVIEWSVIEWTABLESRestriktionen für SQL-AnweisungenSQL-Modus ORACLESQL-SyntaxelementeDatenbankobjektNameNamensraumZugriff auf ObjekteGanze ZahlZahlDatentypPseudospalteOperatorFunktionFormatSQL-Anweisungenalter_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 (embedded SQL)lock_table_statementnoaudit_statementrename_statementrevoke_statementrollback_statementselect_statementset_transaction_statementtruncate_statementupdate_statementSystemtabellenFehlermeldungenMeldungenNummernkreiseVon -1 bis -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-109: LOB file dropped-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 errorVon -900 bis -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 nameVon -1000 bis -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-1405: Missing indicator variable, output parameter with NULL va-1406: Output value truncated-1452: Duplicate secondary key-1556: Data space full-1755: SQL statement will drop further objects (use CASCADE)Von -2000 bis -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 sessioVon -3000 bis -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 parameterVon -4000 bis -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 usergroup 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 schemaVon -5000 bis -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 delimiterVon -6000 bis -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 codeVon -7000 bis -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 sizesVon -8000 bis -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 bis -9799: System errorVon -10000 bis -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 setVon -11000 bis -11099Von -11100 bis -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>.Von -22000 bis -22999-22000: Null values not allowed on more than one long column-22005: Connection timeout occurred. Session reconnectedVon -23000 bis -23999-23050: Unknown error-23051: Could not load system tables for SQL Studio-23052: Could not save object data-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 versionVon -24000 bis -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 ressources afte-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_XPMAX - parameter value higher than maximum 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_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 errorVon -25000 bis -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 (negative values not allo-25210: Invalid SCALE specification. Scale range: -127 <= SCALE-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>]. ConVon -27000 bis -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 users-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 droppe-28902: Too many nested try/catch statements-28903: DBFunction$1 must return a value-28822 bis -28999: Internal ErrorVon 0 bis 19990: Success100: Row not found200: Duplicate key250: Duplicate secondary key300: Integrity violation320: View violation350: Referential integrity violated360: Foreign key integrity violation400: 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 foundVon 25000 bis 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-SicherheitsleitfadenEinführungBevor Sie anfangenTechnische SystemlandschaftBenutzerverwaltung und -authentifizierungKennwörter von Standardbenutzern ändernProtokolldateien auf fehlgeschlagene Anmeldeversuche überprüfenBerechtigungenKlare Berechtigungen für Benutzer definierenNetzwerk- und KommunikationssicherheitKommunikationskanäle absichernMaxDB X-Server hinter einer Firewall verwendenWeb Tools hinter einer Firewall verwendenSicherheit der DatenablageZugriffsrechte auf Datenbankressourcen einschränken (UNIX/LinuxZugriff auf Datenbankressourcen einschränken (Microsoft Windows)Kennwörter von SAP Standard-Betriebssystembenutzern ändernÜberflüssige Funktionen mit Auswirkungen auf die SicherheitMaxDB X-Server bei lokaler Kommunikation ausschaltenMaxDB X-Server ohne NI-Unterstützung starten (UNIX/Linux)Demo-Daten entfernenWeitere sicherheitsrelevante InformationenBenutzereingaben in SQL-Anweisungen überprüfenTrace- und ProtokolldateienZugriff auf Protokolldateien einschränkenAnhang