opitzconsulting / opitzconsulting.ansible_oracle / 4.7.0 / module / oracle_tablespace Manage tablespaces in an Oracle database | "added in version" 1.9.1 of opitzconsulting.ansible_oracle" Authors: Mikael Sandström, oravirt@gmail.com, @oravirtopitzconsulting.ansible_oracle.oracle_tablespace (4.7.0) — module
Install with ansible-galaxy collection install opitzconsulting.ansible_oracle:==4.7.0
collections: - name: opitzconsulting.ansible_oracle version: 4.7.0
Manage tablespaces in an Oracle database (create, drop, put in read only/read write, offline/online)
Can be run locally on the controlmachine or on a remote host
mode: choices: - normal - sysdba default: normal description: The mode with which to connect to the database (normal/sysdba) required: false port: default: 1521 description: The listener port number on the host required: false size: description: - The size of the datafile (10M, 10G, 150G etc) required: false user: description: The Oracle user name to connect to the database required: true state: choices: - present - absent - online - offline - read_only - read_write default: present description: The intended state of the tablespace bigfile: choices: - 'true' - 'false' default: false description: Should the tablespace be created as a bigfile tablespace content: choices: - permanent - temp - undo default: permanent description: - The type of tablespace (permanent, temporary or undo) maxsize: aliases: - max description: 'If autoextend, the maximum size of the datafile (1M, 50M, 1G etc). If empty, defaults to database limits ' datafile: aliases: - df - path description: 'Where to put the datafile. Can be an ASM diskgroup or a filesystem datafile (i.e ''+DATA'', ''/u01/oradata/testdb/test01.dbf'') mutually_exclusive with numfiles ' required: false hostname: default: localhost description: The Oracle database host required: false nextsize: aliases: - next description: - If autoextend, the size of the next extent allocated (1M, 50M, 1G etc) numfiles: description: 'If OMF (db_create_file_dest) is set, you can just specify the number of datafiles you want attached to the tablespace mutually_exclusive with datafile ' required: false password: description: The Oracle user password for 'user' required: true autoextend: choices: - 'true' - 'false' default: false description: - Should the datafile be autoextended tablespace: description: The tablespace that should be managed required: true service_name: description: The database service name to connect to required: true