Timeline for Copy complete structure of a table in Oracle without using Backup
Current License: CC BY-SA 3.0
4 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| Sep 26, 2018 at 14:34 | comment | added | rshdev |
@blubb is correct, I found stackoverflow.com/a/3725621/19961 to have the most accurate syntax and details. And this worked for me: select dbms_metadata.get_ddl('TABLE', 'TABLE_I_WANT_TO_COPY') from dual
|
|
| May 3, 2016 at 11:00 | comment | added | blubb |
I think you accidentally swapped the two last arguments. The correct statement seems to be select dbms_metadata.get_ddl('TABLE','TABLENAME','SCHEMANAME') DDL from dual;
|
|
| May 17, 2012 at 14:55 | vote | accept | jcho360 | ||
| May 17, 2012 at 12:31 | history | answered | Philᵀᴹ | CC BY-SA 3.0 |