I need to copy a few tables(not all) from one schema to another (I am creating new schema from scratch).
What would be most efficient way to do this?
Create table newschema.table as select * from oldschema.table does not seem to be efficient.
I need to copy a few tables(not all) from one schema to another (I am creating new schema from scratch).
What would be most efficient way to do this?
Create table newschema.table as select * from oldschema.table does not seem to be efficient.