Databases

this group of ddl sql statements allows database administrators to manage databases database administrators can create and modify databases, including sso authentication settings you can view information about databases using the sys databases system catalog table for information on database components, see the pages on docid\ m9zbpvfqpm96jidxyhqvi , docid\ yhp4b1irv haf8f3df ww , docid\ g tzn2zxb4zp8w7za8a1k , and docid\ n7zyxmwfavae6fnmv2uvw create database create database creates a new database the database name must be distinct from the name of any existing database in the system to create a database, you must have the create database privilege for the current system syntax create database \[ if not exists ] database name parameter type description database name string a unique identifier for the database the system generates an error if you specify a duplicate name system is a reserved database name and can neither be created nor dropped example create a new database named ocient create database ocient; drop database drop database removes an existing database this sql statement also disconnects all users currently connected to the database to remove a database, you must have the drop database privilege for the current database you cannot drop a database while it has any pipeline in a running status the drop database sql statement removes the existing database and all created users, tables, and views this action cannot be undone syntax drop database \[ if exists ] database name \[, ] parameter type description database name string an identifier for the database to be dropped you can drop multiple databases by specifying additional database names and separating each with commas system is a reserved database name and can neither be created nor dropped example remove an existing database named ocient drop database ocient; alter database alter database rename alter database rename renames an existing database to rename a database, you must have the alter database privilege for the database syntax alter database old database name rename to new database name parameter type description old database name string the old identifier of the database for the rename new database name string the new identifier of the database for the rename example rename an existing database named oracle to ocient alter database oracle rename to ocient; alter database set sso integration alter database set sso integration configures the database to authenticate using an external sso provider this sso integration is the default for connections unless you use a connectivity pool or specify a different provider to set a connection, you must be a system level user or a database administrator and have an open connection to the database this sql statement is an alias for docid\ uy5crlqbr0ymvtqzwna6x see docid\ rurudicbkdqxfu y99p1r for details about configuring sso protocols if your {{ocient}} system is version 25 0 or later, you can create multiple sso integrations for each database an sso integration assigned to the database by the alter database sql statement is the primary sso connection, unless you connect to the database with a connectivity pool that has a different sso integration assigned to it syntax alter database database alter sso integration sso name parameter type description database string the identifier of the database for configuration sso name string the identifier of the sso integration to use example this example sets an example database to use the sso integration named sso test alter database example database set sso integration sso test; alter database alter sso integration alter database alter sso connection configures the database to authenticate using an external sso provider this sso integration is the default for connections unless you use a connectivity pool or specify a different provider to alter a connection, you must be a system level user or a database administrator and have an open connection to the database this sql statement is an alias for docid\ uy5crlqbr0ymvtqzwna6x see docid\ rurudicbkdqxfu y99p1r for details about configuring sso protocols if your ocient system is version 25 0 or later, you can create multiple sso integrations for each database an sso integration assigned to the database by the alter database sql statement is the primary sso connection, unless you connect to the database with a connectivity pool that has a different sso integration assigned to it syntax alter database database alter sso integration sso name parameter type description database string the identifier of the database for configuration sso name string the identifier of the sso integration to use example this example alters an example database to use the sso integration named sso test alter database example database alter sso integration sso test; alter database remove sso integration alter database remove sso integration removes an existing sso integration as the default connection protocol for the database this action effectively undoes the docid\ uy5crlqbr0ymvtqzwna6x sql statement to remove a connection, you must be a system level user or a database administrator syntax alter database database remove sso integration parameter type description database string the identifier of the database for deletion example remove the default connection from the database named example database alter database example database remove sso integration; alter database alter security sets the security settings at the database level using the alter database alter security sql statement replace \<security setting> with the security setting and \<value> with the value syntax alter database database alter security \<security setting> \[=] \<value> parameter data type description database string the identifier of the database for setting security settings security setting string the security setting with values password minimum length password complexity level password no repeat count password lifetime days password invalid attempt limit for details about these values, see docid\ jfltms91v2bfledppksy8 value numeric an integer to represent one of the security settings for details about this value, see docid\ jfltms91v2bfledppksy8 example set the password lifetime to 20 days for the database example db alter database example db alter security password lifetime days = 20; related links docid nwuyof4 i 7wgmmmbf4j docid\ nw9vavkey2v75moxm muo docid\ jfltms91v2bfledppksy8 https //docs ocient com/system catalog