opitzconsulting.ansible_oracle.oracle_tablespace (4.7.0) — module

Install collection

Install with ansible-galaxy collection install opitzconsulting.ansible_oracle:==4.7.0

Add to requirements.yml

  collections:
    - name: opitzconsulting.ansible_oracle
      version: 4.7.0

Description

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

Requirements

• cx_Oracle

Inputs

    
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