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 laterInformation 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 |