How to create an exact copy of a table?

Question

Oracle

How to create an exact copy of a table with all keys and indexes? You need a code/script/procedure, but not a utility.
Tried through dbms_metadata. get _ddl, but there are errors with renaming indexes and keys. How to be? Who faced?

Answer 1

How do you want to create an exact copy without changing the names of the table\indexes\keys?
Here we can only advise you to follow some rules for naming objects in the database, so that after receiving all the scripts, replace the names in them.

Answer 2

Well, the first thing that comes to mind is import/export.
That is, you upload the table in the form of sql code to a file and create it with this code on another server / in another schema.
Second, there is such a COPY command . But I don't remember if it carries keys/triggers.

Answer 3

You can try fitting DBMS_REDEFINITION. But somehow it's crooked.