DBMS_METADATA.GET_DDL Output For Tablespace Inaccurate After Patch 10177856 Applied (Doc ID 1404474.1)

Last updated on DECEMBER 06, 2016

Applies to:

Oracle Server - Enterprise Edition - Version: 11.2.0.2 to 11.2.0.3 - Release: 11.2 to 11.2
This problem can occur on any platform.

Symptoms

DBMS_METADATA.GET_DDL output is corrupted when getting tablespace ddl.

For example:
SQL> set long 10000

SQL> SELECT DBMS_METADATA.get_ddl ('TABLESPACE', 'PSHARE') FROM DUAL

DBMS_METADATA.GET_DDL('TABLESPACE','PSHARE')
--------------------------------------------------------------------------------

CREATE TABLESPACE "PSHARE" DATAFILE
'' SIZE 104857600
AUTOEXTEND ON NEXT 104857600 MAXSIZE 10240M,
'' SIZE 104857600
AUTOEXTEND ON NEXT 104857600 MAXSIZE 10240M,
'/export/oradata/DB10TEST/data01/pshare_01.dbf' SIZE 104857600
AUTOEXTEND ON NEXT 104857600 MAXSIZE 10240M
LOGGING ONLINE PERMANENT BLOCKSIZE 8192
EXTENT MANAGEMENT LOCAL AUTOALLOCATE DEFAULT NOCOMPRESS SEGMENT SPACE MANAGEM
ENT AUTO


NOTE:
There 3 AUTOEXTEND clauses listed for one datafile

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms