Is it possible to pull out table creation scripts from a working Oracle database using some kind of package?
I looked in the direction of DBMS_METADATA, but I did not find a way to get scripts through it.
|
1 answer
DBMS_METADATA.GET_DDL returns the expression CREATE TABLESPACE :
select DBMS_METADATA.GET_DDL('TABLESPACE', 'TS_NAME') from dual instead of TS_NAME name of the desired space.
default locale default locale
13.8k 3 nineteen 36
|