Q: How in Oracle using a copy of the table structure into another table?
A: The specific solution steps are as follows:
1, the structure of a table and copy all the data into a new table:
create table components2 as select * from components
2, just copy the structure of another table without copying the data:
create table components2 as select * from components where id <1000;
Note: components table id minimum value is 1000, so there is less than the minimum if the row selected, then that is the table structure.