System Procedures Index
Procedures in SYS
- getXMLSchemas deprecated
Procedures in SYSADMIN
- addCliTemplate
- addRole
- addSystemProperty
- addUser
- addUserRole
- allowUserLogin
- batchUpdate
- changeCopyOverSourceTableJob
- changeCopyOverSQLJob
- changeIncrementalOptimizationJob
- changeJobParameters
- changeOptimizationJob
- changeResourceOwnerAndExecutor
- changeSQLJob
- changeUserPwd
- checkSortOrder
- cleanOrphanMatTableEntities
- cleanOrphanRemark
- cleanOrphanRemarks
- cleanupJobQueue
- cleanUpStaleMatTables
- clearResultSetCache
- copyOver
- createBackupJob
- createCleanupTaskIfAbsent
- createConnection
- createCreationParam
- createCopyOverSourceTableJob
- createCopyOverSQLJob
- createDataSource
- createGatherStatisticsJob
- createIncrementalOptimizationJob
- createIndex
- createOptimization
- createOptimizationJob
- createOptimizationQuery
- createOrReplaceDatasource
- createQueueHandler
- createSchedule
- createSQLJob
- createVirtualSchema
- deleteOptimization
- deleteRole
- deleteSchedule
- deleteSchedulerJob
- deleteSlackNotification
- deleteStatistics
- deleteSystemProperty
- deleteUser
- deleteUserRole
- deployModularConnector
- disableJobEmailNotification
- disableJobSlackNotification
- dropCliTemplate
- dropIndex
- dropIndexById
- dropIndexByName
- dropQueueHandler
- dropVirtualSchema
- editBackupJob
- editCliTemplate
- editCreationParam
- editQueueHandler
- editSystemProperty
- enableJobEmailNotification
- enableJobSlackNotification
- enableOptimization
- enableSchedule
- enableSchedulerJob
- execExternalProcess
- executeCli
- gatherStatistics
- getAllDataSourcesMetadataDiff
- getAuthMechanism
- getCatalogs
- getClientSecret
- getConnProp
- getCreateTempTablesPermissions
- getCurrentDWH
- getCurrentUser
- getCurrentVdb
- getDataCatalogAttribute
- getDataLineage
- getDataLineageRelationsOnly
- getDataSourceMetadataDiff
- getDataSourcePropertiesHierarchy
- getDefaultOptionValue
- getDriverLogos
- getEncryptedUserPwd
- getGeneratedColumnNames
- getInstalledLicense
- getJobProperty
- getJwtToken
- getReplicatedTableDiff
- getResourceDependencies
- getSchemas
- getServerBuildInfo
- getServerVersion
- getSchemaTmpValue
- getSchemaVersion
- getTypeOfResource
- getViewAndProcCreationOrder
- getXMLSchemas deprecated
- gitCheckout
- gitClone
- gitCommit
- gitDeploy
- gitDiff
- gitExclude
- gitFixConflict
- gitInit
- gitPull
- gitPush
- gitSetRemote
- gitStatus
- hasPermission
- historyUpdate
- importConnection
- importDataSource
- importIndex
- importMatTable
- importOptimization
- importProcedure
- importRecOptSymbol
- importSmtpConfiguration
- importUser
- importView
- isLoggable
- killQuery
- killSession
- leakyBucketReset
- leakyBucketTryConsume
- logMsg
- md5
- purgeObjects
- recreateConnection
- refreshAllDataSources
- refreshAllSchemas
- refreshDataSource
- refreshLdapUserCache
- refreshMatView deprecated
- refreshMatViewRow deprecated
- refreshOptimizations
- refreshSchema
- refreshSSOUserCache
- removeConnection
- removeDataCatalogAttribute
- removeDataSource
- renameRole
- renameUser
- renameVirtualSchema deprecated
- reservedWords
- resetAtomicSchedule deprecated
- resetCliTemplates
- resetSchedule
- sendLicenseFile
- sendOracleADWCWallet obsolete
- sendSlackNotification
- setAllowCreateTempTables
- setColumnStats
- setCurrentDWH
- setDataCatalogAttribute
- setDefaultOptionValue
- setIndexStatus
- setJobProperty
- setOptimizationFrequency
- setPermissions
- setProperty
- setRecOptAllowIndexCreationByType
- setRecOptAllowIndexCreationByStatus
- setRemark
- setSchemaTmpValue
- setSmtpConfiguration
- setTableStats
- startJob
- stopJob
- sleep
- testConnection
- translateColumnName
- translateColumnExpr
- updateSchedule
- webBusinessDataShopPublish
- webBusinessDataShopUnpublish
- writeConnProp
Procedures in SYSADMIN_VDB
- createSSHKeyPair
- createSSHTunnel
- createVdb
- dropVdb
- generateCloudAgentApiKey
- getCloudAgentConfiguration
- getCloudAgentConnectionStatus
- getJavaProp
- importSSHKeyPair
- importSSHTunnel
- removeSSHKeyPair
- removeSSHTunnel
- renameSSHKeyPair
- setJavaProp
- updateCloudAgentConfiguration
Procedures in SYSLOG
- clearFinishedJobLogs
- clearHistory
- clearJobLogs
- clearPerformanceLogs
- clearQueryLogs
- getQueryLogPlan
- getQueryLogDataLineage
Procedures in UTILS
- arrayToTable
- cleanTable
- convertCSVtoTable
- createTable
- csvExport
- detect_file_encoding
- displayRuntime
- download_sftp
- formatTableName
- getIncorrectUpdateColumns
- getModularConnectorDatasourceCreateStatement
- getOrderByColumns
- getSmtpConfiguration
- getTableIntersection
- importSmtpConfiguration
- incrementalReplication
- internal_expandProperties
- isBigQueryTable
- parsePropertiesString
- prepareTargetTable
- returnExtremeValue
- sendCsvExport
- sendMail
- setSmtpConfiguration
- tableExists
- tableToJson
- tableToXml
- tryCast
- tryCastDate
- tryCastTimestamp
- unzip
- upload_sftp
- upsert