If I've got a table like:
CREATE TABLE FRED ( recordId number(18) primary key, firstName varchar2(50) );
Can there be a good way to clone it's structure (not it's data) into another table of the given title. Essentially I wish to create table with the identical structure, but another title, to ensure that I'm able to carry out some functionality onto it. I do in code clearly. Java ideally, but many other languages ought to be similar.
If you are searching a method to discover the exact DDL to recreate the table, such as the storage clause, you should use
select dbms_metadata.get_ddl('TABLE', 'TABLE_NAME', 'SCHEMA_NAME') from dual
as referred to here.
CREATE TABLE tablename AS Choose * FROM orginaltable WHERE 1=2
Edit: The WHERE clause forbids any rows from being approved.