If you want to take a copy of one table and make a copy ofit in another schema (under another username), you can use the SQL*Plus COPYcommand, or a simple <code>"createtable foo as select * from other ...

CREATE OR REPLACE TABLE DATE_DIM_CLONE CLONE DATE_DIM; CREATE OR REPLACE TABLE PAYMENT_DIM_CLONE CLONE PAYMENT_DIM; CREATE OR REPLACE TABLE PRODUCT_DIM_CLONE CLONE ...

This document introduces the Table Clone feature of Microsoft Fabric's Data Warehouse, which allows quick creation of table copies with minimal storage impact, preserving the original data's integrity ...