itd27m01.oracle.oracle_tablespace (0.1.5) — module

Install collection

Install with ansible-galaxy collection install itd27m01.oracle:==0.1.5

Add to requirements.yml

  collections:
    - name: itd27m01.oracle
      version: 0.1.5

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