Table of Contents
Get Started
Tasks
- Data Dictionary
- Get a database link
- Get a partition
- Get a procedure that is defined in package
- Get a specific column
- Get a specific foreign keys
- Get a specific function
- Get a specific index
- Get a specific object
- Get a specific table
- Get a specific tablespace
- Get a synonym
- Get all arguments for functions and procedures
- Get all database links
- Get all database objects
- Get all foreign keys
- Get all functions
- Get all indexes
- Get all materialized view logs
- Get all object types
- Get all partitions in the database
- Get all procedures defined in package
- Get all synonyms in the database
- Get all table columns
- Get all tables
- Get all tablespaces
- Get an argument
- Get an object type
- Get information on a specific materialized view log
- Data Guard
- Add a configuration
- Add a database
- Alter a configuration property
- Convert, enable, disable, or set the role of a database
- Delete the current database from the broker
- Delete the Data Guard instance
- Enable or disable a configuration
- Get a database Data Guard property
- Get the current broker configuration
- Get the current broker configuration database
- Get the current broker configuration databases
- Get the current broker configuration properties
- Get the current broker database instances information
- Get the database Data Guard properties
- Get the specified broker configuration property
- Remove the configuration
- Set the value of a database Data Guard property
- Data Pump
- Data Tools
- Creates Cloud Storage Link
- Creates credentials
- Creates data load jobs
- Creates Live Table Feed
- Delete a Cloud Storage Link
- Delete a credential
- Delete data load job
- Delete Live Table Feed
- Gets Cloud Storage Links
- Gets credentials
- Gets data load jobs
- Gets Live Table Feed notification key
- Gets Live Table Feeds
- Gets progress of data load job
- Gets specific Cloud Storage Link
- Gets specific credential
- Gets specific data load job
- Gets specific Live Table Feed
- Modify Live Table Feed
- Surveys input data
- Triggers data load for Live Table Feed
- Environment
- Create a new database in the default Oracle Home
- Create a new database in the specified Oracle Home
- Create a new DBCA job in the default Oracle Home
- Create a new DBCA job in the Oracle Home
- Delete the specified DBCA job in the default Oracle Home
- Delete the specified DBCA job in the default Oracle Home
- Get a list of the databases defined in an Oracle Home
- Get a list of the databases defined in the default Oracle Home
- Get a list of the DBCA database templates defined in an Oracle Home
- Get a list of the DBCA database templates defined in the default Oracle Home
- Get a list of the DBCA jobs created through ORDS Database API in the default Oracle Home
- Get a list of the DBCA jobs created through ORDS Database API in the Oracle Home
- Get a specific database defined in a specific Oracle Home
- Get a specific database defined in the default Oracle Home
- Get a specific database template file in a specific Oracle Home
- Get a specific database template file in the default Oracle Home
- Get a specified DBCA jobs created through ORDS Database API in the default Oracle Home
- Get a specified DBCA jobs created through ORDS Database API in the specified Oracle Home
- Get database Oracle Homes
- Get the DBCA log file content for a specified DBCA jobs created through ORDS Database API in the default Oracle Home
- Get the DBCA log file content for a specified DBCA jobs created through ORDS Database API in the specified Oracle Home
- General
- Create a data pump job
- Get a database component
- Get a description of a specific local listener for this database
- Get a description of all local listeners for this database
- Get a specific database parameter
- Get a specific database user
- Get a tablespace segment
- Get all database components
- Get all database parameters
- Get all database users
- Get all feature usage statistics
- Get all tablespaces storage data
- Get data file usage summary for a specific tablespace
- Get data files for a tablespace
- Get database status
- Get database version
- Get specific database Oracle Home
- Get storage for a specific tablespace
- Get storage statistics
- Get tablespace data file
- Get tablespace data file usage
- Get tablespace segments
- Get tablespace space usage history
- Get tablespace temporary file
- Get tablespace temporary file usage
- Get temporary file usage summary for a specific tablespace
- Get temporary files for a tablespace
- Get usage statistic for a feature
- Monitoring
- Get a session
- Get a session lock that is blocking other sessions
- Get a specific lock that a session is waiting on
- Get a specific session lock record
- Get a specific session wait
- Get a specific session wait class record
- Get all alerts
- Get all current sessions
- Get all locks held in the database
- Get all locks that are blocking other sessions
- Get all locks that sessions are waiting on
- Get all long running operations for a session
- Get all session limits
- Get all session wait class records
- Get all session waits
- Get all wait class metrics
- Get an alert record
- Get count of alerts by message level
- Get count of alerts by message type
- Get count of different session types
- Get count of recent alerts by message level
- Get count of recent alerts by message type
- Get current active process for a session
- Get time totals for all registered wait classes
- Get wait time summary from recent active session history records
- Open Service Broker
- Oracle APEX
- Create or Update an APEX application, with a specific application id, in the specified workspace
- Delete the specified APEX application
- Export APEX application components
- Get all applications in the specified workspace
- Get all workspaces
- Get application statistics
- Get application statistics
- Get instance overview
- Get instance statistics
- Get or export a specific APEX application
- Get workspace
- Oracle Transactional Event Queues
- Create a Consumer Group
- Create a new Transactional Event Queue Topic
- Create Consumer Instance
- Delete a Consumer Group
- Delete Consumer Instance
- Delete the Transactional Event Queue Topic with the specified topic_name
- Describe the specified Transactional Event Queue Topic Partition
- Describe Transactional Event Queue Topic Partition specified in Cluster
- Describe Transactional Event Queue Topic Partitions
- Describes Transactional Event Queue Topic in Cluster
- Fetch messages for the specified Consumer
- Get a Consumer Group
- Get all Transactional Event Queue Topics in the schema
- Get Consumer Groups in Cluster
- Get consumer lag for Transactional Event Queue Topic Partition
- Get Consumer last Commit Offsets
- Get description of a particular Transactional Event Queue Topic.
- Get lag summary for Consumer Groups in Cluster
- Get Transactional Event Queue Topic Partition Offsets
- Lags/Offsets of consumers in the Consumer group
- List Partitions for a Transactional Event Queue Topic in Cluster
- List Transactional Event Queue Topics that belong to the specified database cluster
- Produce a message to the Transactional Event Queue Topic specified by topic_name
- Produce messages in the specified Transactional Event Queue Topic Partition
- Seek to End of Partitions for Consumer Group
- Seek to specified Transactional Event Queue Topic partition offsets for Consumer Group
- Seek to start of Partitions for Consumer Group
- Subscribed list of Transactional Event Queue Topics
- ORDS REST Services
- Create a REST handler parameter
- Create a REST module
- Create a REST module template
- Create a REST template handler
- Create an ORDS OAuth client
- Create an ORDS privilege
- Create an ORDS role
- Delete a REST handler parameter
- Delete a REST module template
- Delete a REST template handler
- Delete an ORDS OAuth client
- Delete an ORDS privilege
- Delete an ORDS role
- Get a REST enabled object
- Get a REST enabled object metadata
- Get a REST handler parameter
- Get a REST handler source
- Get a REST module
- Get a REST module source
- Get a REST module template
- Get a REST template handler
- Get all current schema recent REST objects
- Get all ORDS OAuth clients
- Get all ORDS privileges
- Get all ORDS privileges for a specific role
- Get all ORDS privileges in an OAuth client
- Get all ORDS properties values
- Get all ORDS roles
- Get all ORDS roles in a privilege
- Get all ORDS roles in an OAuth client
- Get all protected REST modules
- Get all REST enabled objects
- Get all REST handler parameters
- Get all REST module templates
- Get all REST modules
- Get all REST modules in a privilege
- Get all REST patterns in a privilege
- Get all REST template handlers
- Get an ORDS OAuth client
- Get an ORDS privilege
- Get an ORDS property value
- Get an ORDS property value for a schema
- Get an ORDS role
- Get count of all the REST enabled objects
- Get current ORDS schema and count of all current schema REST objects and count of all REST modules
- REST enable an object
- Set an ORDS property value
- Set an ORDS property value for a schema
- Unset an ORDS property value
- Unset an ORDS property value for a schema
- Update a REST handler parameter
- Update a REST module
- Update a REST module template
- Update a REST template handler
- Update an ORDS OAuth client
- Update an ORDS privilege
- Update an ORDS role
- Update or disables a REST enabled object
- Updates the ORDS OAuth client avatar image.
- Performance
- Get a specified sampled session activity in the database
- Get all sampled session activity in the database
- Get all SQL statements ordered by CPU time descending
- Get execution plan for an SQL Statement
- Get historical statistics for a SQL statement
- Get information on a monitored statement
- Get monitoring statistics for a SQL Statement
- Get parallel execution information for specific statement execution
- Get SQL statement
- Get SQL statistics for a specific session
- Get SQL statistics maximum values
- Get statistics for a SQL statement
- Get statistics for all SQL statements
- Get the last 10 wait events for each active session
- Get the specified wait event for specific active session
- Pluggable Database Lifecycle Management
- Create a Pluggable Database
- Drop a PDB
- Get a pluggable database
- Get all pluggable databases
- The list of all snapshots taken for the specified pluggable databases (PDBs)
- The snapshots of all pluggable databases (PDBs) in the Container Database
- The specific snapshot taken of the specific pluggable databases (PDBs)
- Update a specific PDB
- Pluggable Database Snapshot Carousel
- Configure automatic PDB snapshots.
- Create snapshot of the current pluggable databases, the name will be generated
- Create snapshot of the current pluggable databases, the name will be {snapshotName}
- Delete the specified snapshot
- get all snapshots of the current pluggable databases
- Get snapshot mode in current PDB
- Get specific snapshot based on the name in current PDB
- RDF Graph
- Append a graph
- Create entailment
- Create RDF model
- Create RDF network
- Create virtual model
- Delete a graph
- Drop entailment
- Drop RDF model
- Drop RDF network
- Drop virtual model
- Entailment information
- Execute a SPARQL query
- Execute a SPARQL query or update
- Execute full text search
- Get a graph
- List entailments
- List RDF models
- List RDF networks
- List virtual models
- RDF model information
- RDF network information
- Replace a graph
- Translate SPARQL to SQL
- Translate SPARQL to SQL
- Virtual model information
- Scheduler