Copying and moving a table

 

You can copy or move tables from one schema or system to another. By copying a table, you create more than one instance of the table. By moving a table, you transfer the table to its new location while removing the instance from its former location.

• Copying a table
  In this example, you copy the INVENTORY_LIST table to another schema.

• Moving a table
  Now that you have copied the INVENTORY_LIST table to the LIBRARY1 schema, move the SUPPLIERS table to LIBRARY1.

 

Parent topic:

Creating a table and defining a column