My Oracle Support Banner

DBMS_METADATA.GET_DDL Tablespace Getting Incorrect DDL Syntax. (Doc ID 3003227.1)

Last updated on JULY 20, 2024

Applies to:

Oracle Database - Enterprise Edition - Version 19.3.0.0.0 and later
Information in this document applies to any platform.

Symptoms

DBMS_METADATA.GET_DDL tablespace getting incorrect ddl syntax.

GET_DDL of any Tablespace if being used to create new Tablespace is erroring out with below error:-

Example

++++++

SELECT DBMS_METADATA.GET_DDL('TABLESPACE', 'XXX') AS ddl FROM dual;

CREATE TABLESPACE "XXX" DATAFILE 'DATAFILE NAME' SIZE 34359721984
AUTOEXTEND ON NEXT 34359721984 MAXSIZE 32767M
LOGGING ONLINE PERMANENT BLOCKSIZE 8192
EXTENT MANAGEMENT LOCAL AUTOALLOCATE DEFAULT
ROW STORE COMPRESS ADVANCED SEGMENT SPACE MANAGEMENT AUTO;

If this is being used to create new tablespace with above DDL, we get below error:-

ORA-02494: invalid or missing maximum file size in MAXSIZE clause 

 

 

 

Changes

 No changes in the environment.

Cause

To view full details, sign in with your My Oracle Support account.

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


In this Document
Symptoms
Changes
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.