I want to create tables from one schema to another. i.e. complete table script. eg: Let say in schema 'A' tables are present and need to create in schema 'B'. Can we do this with a scripts as there are lot of tables? or manually is the only option? Could anyone pls suggests.
Thanks.