copy table structure [message #661350] |
Wed, 15 March 2017 11:46 ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
![](http://www.gravatar.com/avatar/3435de62d7a517bfdbcb53d8afd9e4b9?s=64&d=mm&r=g) |
asliyanage
Messages: 60 Registered: January 2017
|
Member |
|
|
I need to create a copy of table in same database. what is the best way to do this without creating manually table ?
copy means same columns with same data types.
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Re: copy table structure [message #661523 is a reply to message #661519] |
Wed, 22 March 2017 09:08 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) |
cookiemonster
Messages: 13925 Registered: September 2008 Location: Rainy Manchester
|
Senior Member |
|
|
The first reply in this thread, from Michel, lists three methods. The two you skipped were repeated further down.
Pay attention to what others write.
|
|
|