Recreating a Schema’s Tables in Another Schema

SELECT 'CREATE TABLE ' || table_name || ' '
|| 'AS SELECT * FROM SCHEMA_ISMI.' || table_name
||' ;'
AS "Create Table Script"
FROM all_tables
where
owner = 'SCHEMA_ISMI';

SELECT 'CREATE TABLE ' || table_name || ' '

|| 'AS SELECT * FROM SCHEMA_ISMI.' || table_name

||' ;'

AS "Create Table Script"

FROM all_tables

where

owner = 'SCHEMA_ISMI';