I want to copy existing table from one schema to another without changing anything
I am trying to copy 1 table from 1 schema into another schema in non existing table using DBVizualizer or SQL Developer. Also if possible just for testing purposes will need example how to copy 1 table into another (non existing table) in the same schema.
I would really appreciate any help.
Have tried this:
SELECT *
INTO new_table
FROM old_table;
ALTER TABLE old_table
RENAME TO new_table;
in both DBVizuallizer and SQL Developer doesn’t work and I am not really sure what I have done since it was copy paste from w3school.