Oracle Tables Copy Remote

You might need to backup a table in order to modify without risks, so do:

SQL> CREATE TABLE locations_copy AS SELECT * FROM LOCATIONS;

Table created.

SQL>

Later you can alter the table name doing:
SQL> ALTER TABLE locations RENAME TO locations_wrong;

Table altered.

SQL>